> SELECT > A.ORDER_NO, > A.SOLD_TO_CUST_ID, > B.NAME1(1), > A.BILL_TO_CUST_ID, > B.NAME1(2), > A.ORDER_GRP, > FROM > PS_ORD_HEADER A, > PS_CUSTOMER B > WHERE > A.ORDER_NO = 'OE-1062283' > AND > ?? A.SOLD_TO_CUST_ID = B.CUST_ID ?? > > > I have no idea how to pull one field from the same record twice in the > same query based on two separate key fields for two separate results.
<scooby>ZOIKS!!!</scooby> .b ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
