select customer.customer-name from customer where customer.customer-id=192-83-7465 --这里的192-83-7465是一个字符串了,要用 '' select customer.customer-name from customer where customer.customer-id='192-83-7465'
--#1 select a.[customer-name] from customer a where a.[customer-id]='192-83-7465' --#2 select [customer-name] from customer where [customer-id]='192-83-7465'
select customer.customer-name
from customer
where customer.customer-id=192-83-7465 --这里的192-83-7465是一个字符串了,要用 '' select customer.customer-name
from customer
where customer.customer-id='192-83-7465'
楼主,customer.customer-name 你确定是这样而不是customer.customer_name么?
customer.customer-id同理,customer.customer-id=192-83-7465是否是customer.customer_id='192-83-7465' ?
select a.[customer-name]
from customer a
where a.[customer-id]='192-83-7465'
--#2
select [customer-name]
from customer
where [customer-id]='192-83-7465'