select * from (select A.*,B.* from tab1,tab2) A、B有同名外键字段 xxx_id
如在外面再套个查询就会报[Error Code: 918, SQL State: 42000] ORA-00918: 未明确定义列
select * from (select * from (select A.*,B.* from tab1,tab2))AB2表字段比较多 不想一一列出来哦 有好的办法没?
如在外面再套个查询就会报[Error Code: 918, SQL State: 42000] ORA-00918: 未明确定义列
select * from (select * from (select A.*,B.* from tab1,tab2))AB2表字段比较多 不想一一列出来哦 有好的办法没?
select * from (select A.*,B.* from tab1 a,tab2 b)