select a.accountnum, b.name from custTable a join dirPartyTable b on b.recid = a.party where a.accountnum like 'MINSK32680'Output:
accountnum name -------------------- ------------------------- MINSK32680 MINSK WHEEL TRACTOR PLANT (1 row(s) affected)
No comments:
Post a Comment