如何将一个a表a1字段与b表b1字段的笛卡尔积插入到e表中

insert into e (a1,b1) select c.a1,d.b1 from (select a.a1 from a) c cross join (select b.b1 from b) d ;

  

原文地址:https://www.cnblogs.com/cgy-home/p/11609243.html