>>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'
>
>Do you have multiple items for this customer in Table2? If yes, what criteria do you want to use to get only one item?

Here are the tables.
table 1

JONES TAPE DISPENSER 7VS0055
JONES LABELS 7VS0056
JONES POWER CORD 7VS0057

table 2


JONES TONER CARTRIDGE GPR16 8RV0155
JONES FILTER CAP HYDROSTAT RESERVOI 8RV0216
JONES INKJET PRINT CARTRIDGE HP #57 8RV0257