SQL跨表查询问题(100分)

J

jansyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-05-02

• #1

两个查询： 一个产品信息qry_cp，一个进货单qry_jh(cpid与jhid一致)<br>想通过SQL语句查询进货单表中不同产品的信息。<br>with qry_cp do<br>begin<br>&nbsp; sql.clear;<br>&nbsp; sql.add('select * from qry_cp where cpid in (select distinct jhId from qry_jh )');<br>&nbsp; active:=true;<br>end;<br>&nbsp; &nbsp;编译通过，但执行出错，请求指教!数据库是ACCESS

 

J

jenhon

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-05-02

• #2

'select * from qry_cp where cpid in (select distinct jhId as cpid from qry_jh )'

 

J

jenhon

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-05-02

• #3

不过最好减少使用 in 、not in 的语句，太慢了。

 

D

dcs_dcs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-05-02

• #4

with qry_cp do<br>begin<br>&nbsp; close;<br>&nbsp; sql.clear;<br>&nbsp; sql.add('select * from qry_cp where cpid in (select distinct jhId from qry_jh )');<br>&nbsp; open;<br>end;

 

K

kukujaky

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-05-03

• #5

select b.TheCode, b.TheName<br>from qry_jh a<br>left outer join qry_cp b on b.cpid=a.jhid