insert into Dselect * from (select C.*from A,Cwhere A.id=C.idunionselect B.*from A,Bwhere A.id=B.id)
insert into 结果表 (字段1，字段2,字段3,xxxx) select 字段1，字段2，字段3，XXX from b,c where id=xx
