问下2个sql语句如何接成一张表

问下2个sql语句怎么接成一张表
就是有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