버전 13 (anonymous에 의해 수정됨, 11 년전)
--
@ 판매처 상세 리스트==> select  a.seq1, a.ticketCode, a.ticketName,
                        nvl((select b.isVat from ticketMessroom b where b.cateringcode=a.cateringco de and b.messroomcode=a.messroomcode and b
        from    buyerSelling01Detail a
        where   a.cateringcode= 'A99'
        and             a.messroomcode= '101'
        and             a.buyerCode     = '100003'
        and             a.buyingDay     = '20140130'
        and             a.seq           = '1'