What would be the syntax to get the ctrl#,item from 2 like tables where customer='JONES'? My syntax returns duplicates from table 2.
SELECT a.ctrl,a.item,b.ctrl,b.item FROM e:csu8 a , e:csu7 b ;
WHERE a.cust_name = b.cust_name AND a.cust_name='JONES'
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."