水晶报表如何写SQL 命令
水晶报表 用SQL 命令 这样写哪里有错？？
select 'Customer'.'Customer Name' as 'Name',
'Customer'.'City' as 'City',
'Orders'.'Order Amount' as 'Amount',
'Orders'.'Order Date' as 'Date'
from
'Customer' inner join 'Orders' on
 'Customer'.'Customer ID' = 'Orders'.'Customer ID'
请帮忙指出

------解决方案--------------------
建議你先寫一個表的SQL語句，用排除法。