水晶报表中主表MainTable
Id, Customer name data1, data2 明细表:
Id, dt1, dt2,dt3;
要求表的内容如下:
根据输入的ID, Id, Customer name data1, data2
dt1, dt2,dt3;
dt1, dt2,dt3;
dt1, dt2,dt3;
请教各位高手!!!!
Id, Customer name data1, data2 明细表:
Id, dt1, dt2,dt3;
要求表的内容如下:
根据输入的ID, Id, Customer name data1, data2
dt1, dt2,dt3;
dt1, dt2,dt3;
dt1, dt2,dt3;
请教各位高手!!!!
SELECT * FROM MainTable,DetailTable
WHERE MainTable.Id = DetailTable.Id AND MainTable.Id = 输入的ID