:),为什么要用变量?'Select * from Detail where Detail.ID ='+Master.fieldbyname('id')+'''';显示两个表的内容是这样的,利用冗余;Select a.*, b.* from detail a, master b where a.id = b.id;
DataSource1.dataset := query1; query1.sql.add('select * from table1');query2.datasource := datasource1; query2.sql.add('select * from table2 where myfield = :filedxx')
query1.sql.add('select * from table1');query2.datasource := datasource1;
query2.sql.add('select * from table2 where myfield = :filedxx')