Figured it out:
SELECT
A.ORDER_NO,
A.SOLD_TO_CUST_ID,
B.NAME1(1),
A.BILL_TO_CUST_ID,
C.NAME1(2),
A.ORDER_GRP,
FROM
PS_ORD_HEADER A,
PS_CUSTOMER B,
PS_CUSTOMER C,
WHERE
A.ORDER_NO = 'OE-1062283'
AND
A.SOLD_TO_CUST_ID = B.CUST_ID
AND
A.BILL_TO_CUST_ID = C.CUST_ID
I was 100% unaware that a table could be referenced or joined twice.
Notice that B and C are the same table. Cewl stuff!
Casey
____ � 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]
