我怎么写不对下面这一句:
ssql = insert into table3(res1,res2) values(select m as res1 from table1,table2 where n = '1',select m as res2 from table1,table2 where m = '1')
然后执行
ssql = insert into table3(res1,res2) values(select m as res1 from table1,table2 where n = '1',select m as res2 from table1,table2 where m = '1')
然后执行
从两个表中读取数据?
两个表的关联关系?
如果rest1,rest2是table3下的字段的话,SQL 可以改造为:
ssql = insert into table3(res1,res2) values((select m from table1,table2 where n = '1'),(select m from table1,table2 where m = '1'))
--简单的括号问题!