如果数据库表名与关键字冲突怎么办？

[hellopls]

在sql server2000里的northwind中有表格customer and suppliers by city
如果要对这个表格进行查询，写这样的语句
select * from customer and suppliers by city
是会报错的。
但是怎么样解决了？

[hellopls]

在线等待

[caiyunxia]

select * from table1,table2 where ...

[hellopls]

customer and suppliers by city是一个表格的名字，不信你可以去看一看

[ldcr520]

select * from [customer and suppliers by city]

[ldcr520]

select * from "customer and suppliers by city"

[seasong]

select * from [customer and suppliers by city]

[mjhnet]

select * from [customer and suppliers by city]

[miller3000]

select * from [Customer and Suppliers by City]

[hellopls]

这种方法是对的select * from [customer and suppliers by city]
如果要数据库的话，可以是这样
select * from northwind..[customer and suppliers by city]

多谢大家了！！

[wbf420]

努力！朋友！

[hellopls]

不过该怎么样给分了
后面的都和ldcr520是一样的答案
：（

明天给分

[hellopls]

不过该怎么样给分了
后面的都和ldcr520是一样的答案
：（

明天给分

[nboys]

exec master..sp_rename 'customer and suppliers by city','customer'
select * from northwind..customer

[hellopls]

改名字也是个好办法，不过我用的是动态的创建，所以。。。嘿嘿
谢了先