财务软件版1楼: 有两个表:
Table1:(字段)
ID1,ID2

Table2:(字段)
ID1,ID3,ID4

现要求得到ID2,ID3,该如何查询？

2楼: select Table1.ID2,Table2.ID3
from Table1,Table2
where Table1.ID1=Table2.ID1 如商贸财神进销存

3楼: select a.id1,a.id2,b.id3,b.id4 from table1 as a inner join table2 as b on.id1=b.id2

QQ:136293586

4楼: select ID2,ID3 from Table1 as a join Table2 as b on a.ID1=b.ID1

5楼: select Table1.ID2,Table2.ID3
from Table1,Table2
where Table1.ID1=Table2.ID1

6楼: 多人接受答案了。