水晶报表如何写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句，用排除法。