求查询双表双条件SQL语句

huangyu_info · 发表于 2010-12-7 15:21:25

我不会写这样的SQL语句，思路是这样的：
SELECT * FROM "uchome_space" WHERE "avatar"=1 and (SELECT * FROM uchome_magicuselog where mid="superstar" and expire-dateline != 86400 ORDER BY dateline DESC)
当然上面这个是语法错误。求正确的写法。。。谢谢

miaodo · 发表于 2010-12-7 18:17:17

SELECT * FROM `uchome_space` A,`uchome_magicuselog` B Where A.uid =B.uid;

通过uid关联起来,具体的过滤条件,楼主,自己加吧,如 A.avatar=1 And B.mid='superstar'

		自动登录	找回密码
密码			立即注册

[求助] 求查询双表双条件SQL语句