就是有2个SQL
- SQL code
select * from(select t.NAME,p.ORDER_ID from song.TICKET_CATOGORY e left join song.PARK_TICKET a on a.ID=e.ID left join song.PARK t on t.ID=a.PARK_ID left join song.ORDER_DETAIL p on p.PARK_TICKET_ID=e.ID) aa,(select N.ID, M.LOGIN_NAME, N.BILL_NO,N.PAY_TYPE,N.PAY_STATUS,N.CHECK_FLAG,N.refundment,N.UPDATE_FLAG, N.CONTACT_ID,N.TICKET_TIME,N.FINAL_SUM from song.ORDER_DETAIL P, song.ORDER_INFO N left join song.ACCOUNT M on N.CONSUMER_ID=M.ID) bbwhere aa.ORDER_ID=bb.ID
怎么接成一张表 比方说A表查出是A1A2列B表查出是A3A4列，怎么通过A3A42个相同的值组成A1A2A4列啊 我这样写一直在循环。。
------解决方案--------------------