水晶报表如何写SQL 命令

[nicho123456]

水晶报表 用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'
请帮忙指出

[wtnu200]

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]

[wtnu200]

从学习sql到现在，从来没看到列名中加空格的，你列名中有空格？

[walkingboy]

列名有空格很正常呢。報什么錯啊，給個圖看看。

[walkingboy]

建議你先寫一個表的SQL語句，用排除法。