一个简单的查询SQL

[peppi_2000]

SELECT * FROM PHONE_CLIENT WHERE CALL_TIME = '2003-3-6'
AND PHONE_CLIENT.CLIENT_ID ,PHONE_CLIENT.USER_ID
NOT IN (SELECT ORDERS.CLIENT_ID,ORDERS.USER_ID FROM ORDERS WHERE ORDER_DATE='2003-3-6' )

我想实现的是查表PHONE_CLIENT里的数据,条件是CALL_TIME为某日,此表内的CLIENT_ID和USER_ID在表ORDERS内没有相应的记录的数据.也就是说查表PHONE_CLIENT内ORDERS内没有的数据.
我这么写,好象不行,请问该怎么写?CLIENT_ID和USER_ID都不唯一,但它们俩和ORDERS_DATE在一起是唯一的.

[lrlrlr]

SELECT * FROM PHONE_CLIENT WHERE CALL_TIME = '2003-3-6'
AND PHONE_CLIENT.CLIENT_ID and PHONE_CLIENT.USER_ID
NOT IN (SELECT ORDERS.CLIENT_ID,ORDERS.USER_ID FROM ORDERS WHERE ORDER_DATE='2003-3-6' )

将逗号改为and，where后面不能跟逗号！

[peppi_2000]

楼上的,我试了,不行 and 有错

[brook_huang]

SELECT * FROM PHONE_CLIENT WHERE CALL_TIME = '2003-3-6'
AND (PHONE_CLIENT.CLIENT_ID+PHONE_CLIENT.USER_ID) AS ID
NOT IN (SELECT (ORDERS.CLIENT_ID+ORDERS.USER_ID) AS ID FROM ORDERS WHERE ORDER_DATE='2003-3-6' )

[lrlrlr]

请问换成and后报什么错？
要在什么地方用这个查询！

[scy_cd]

SQL要是这么写，如果表大查询会很慢的

[tchatcha]

SELECT * FROM PHONE_CLIENT WHERE CALL_TIME = DATE'2003-3-6'
AND PHONE_CLIENT.CLIENT_ID
NOT IN (SELECT ORDERS.CLIENT_ID FROM ORDERS WHERE ORDER_DATE=DATE'2003-3-6' )
AND PHONE_CLIENT.USER_ID NOT IN (SELECT ORDERS.USER_ID FROM ORDERS WHERE ORDER_DATE=DATE'2003-3-6' )

[hanps]

SELECT * FROM PHONE_CLIENT WHERE CALL_TIME = '2003-3-6'
AND (pHONE_CLIENT.CLIENT_ID ，PHONE_CLIENT.USER_ID)
NOT IN (SELECT ORDERS.CLIENT_ID,ORDERS.USER_ID FROM ORDERS WHERE ORDER_DATE='2003-3-6' )

肯定对

[boyfu]

那些东西只有在了解
用途和表的结构后才可能有优化的办法啊