这样的SQL语句如何写？ ( 积分: 100 )

S

super-ljc

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #1

有三个表
A表
cjid 100
cjmc 提取车间
b表
bzid 100
bzmc 粉碎组
C表
wid 10000
wmc 张三
cjid 100
bzid 100
想查出如下结果： 张三，前提车间，粉碎组 在access中应如何写 sql 语句呢？

 

J

Johnny_du

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #2

SELECT C.WMC,A.CJMC,B.BZMC FROM A,B,C WHERE (C.WMC='张三') AND (A.CJID=C.CJID) AND (B.BZID=C.BZID)

 

J

jiayuzhu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #3

SELECT C.WMC,A.CJMC,B.BZMC FROM A,B,C WHERE (A.CJID=C.CJID) AND (B.bzid=C.bzid)

 

A

angellover

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #4

mo ming qi miao

 

红

红军

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #5

太简单了吧？
同意Johnny_du的结果

 

M

maikee1978

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-15

• #6

这家伙人来不结帖的

 

贝

贝尔

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-15

• #7

select c.wmc,a.cjmc,b,bzmc from a,b,c
where a.cjid=c.cjid and b.bzid=c.bzid