主从表问题。

[simonzone]

怎么取得主表当前记录相关的从表的记录。
我用select * from table1,table2 where table1.id=table2.id
从表会显示与主表id相同的全部记录。
怎么办。

[liupanwin]

select table1.id,table1.column1,table1.column2... from table1,table2 where table1.id=table2.id

[newly_ignorant]

不太明白意思

select * from table2 where id in (select id from table1 where...)

[zhujiechang]

SHAPE {select id,mc from table1} AS ParentCMD APPEND ({select dm,mc from table2 } AS ChildCMD RELATE id TO dm) AS ChildCMD