SQL两个表查询的问提 ( 积分: 100 )

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #1

user表
userid,username,jf
73 abc 1
74 def 1
75 aaa 1
dj表
userid,username,djs
74 abc 1
74 def 1
75 abc 1
在user表fj>0的数据列出
条件为dj表中的abc对应的userid不列出
最后列出数据为
73 abc 1

 

A

admin2008

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-28

• #2

看了下你的userid不一样呀
select * from user a,dj b where a.userid=b.userid and a.fj>0
看不懂你的意思了 你这表是不是有问题哟

 

S

s00000000001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-29

• #3

select *
from [user]
where jf > 0 and userid not in (select userid from dj where username = 'abc')

 

D

Delphiguanshui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-29

• #4

樓上說的都對，

 

S

shadowpj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-29

• #5

你的意思是不是说列出 user表中jf 大于0 并且 userid no in username=dj 的username中的记录
select userid,username from user where jf>0 and userid not in (select userid from jf where username=user.username)

 

S

skyroom007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-29

• #6

SELECT userid FROM user WHERE (userid NOT IN(SELECT userid FROM dj))