버전 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'