简单的sql语句问题!!!紧急！！

yilian_wusi

在t1(id,id1)中选出当id1=1时，与t2(id,id1)不同的记录:
SELECT id,id1 FROM t1 WHERE id1=1 AND id NOT EXISTS (SELECT id FROM t2 WHERE id1=1) ORDER BY id";
以上是错误语句，请帮忙修改！！

welbird

SELECT id,id1 FROM t1 WHERE id1=1 AND id NOT in (SELECT id FROM t2 WHERE id1=1) ORDER BY id";
如果是mysql较新版本的话

mikespook

SELECT * FROM t1,t2 WHERE t1.id = 1 AND t1.id<>;t2.id

不知道我理解对你的意思没有~~~

yilian_wusi

原帖由 "welbird" 发表：
SELECT id,id1 FROM t1 WHERE id1=1 AND id NOT in (SELECT id FROM t2 WHERE id1=1) ORDER BY id";
如果是mysql较新版本的话

解决问题
多谢各位 !

gunguymadman007

原帖由 "mikespook" 发表：
SELECT * FROM t1,t2 WHERE t1.id = 1 AND t1.id<>;t2.id

不知道我理解对你的意思没有~~~

cool