select MXKJ_giftsget.*,MXKJ_Customer.dw_name,MXKJ_person.mobile,MXKJ_person.phone,MXKJ_gifts.gname from MXKJ_giftsget inner join MXKJ_Customer on MXKJ_giftsget.cid=MXKJ_Customer.CustomerID inner join MXKJ_person on MXKJ_giftsget.contact=MXKJ_person.personname inner join MXKJ_gifts on MXKJ_giftsget.gid=MXKJ_gifts.gid这个四表联合查询语句,在access中执行查询时,总是提示
语法错误 操作符丢失 在查询表达式.....我将以上的句子修改,只保留两个表联合查询,又是可以正常查询的。这个语法哪儿有错啊?
语法错误 操作符丢失 在查询表达式.....我将以上的句子修改,只保留两个表联合查询,又是可以正常查询的。这个语法哪儿有错啊?
,MXKJ_Customer.dw_name
,MXKJ_person.mobile
,MXKJ_person.phone
,MXKJ_gifts.gname
from ((MXKJ_giftsget
inner join MXKJ_Customer on MXKJ_giftsget.cid=MXKJ_Customer.CustomerID )
inner join MXKJ_person on MXKJ_giftsget.contact=MXKJ_person.personname )
inner join MXKJ_gifts on MXKJ_giftsget.gid=MXKJ_gifts.gid
非常感谢jwdream2008!!