SELECT tablea.service as totalSalesService,tablea.name from tablea ; WHERE NOT tablea.name in (Select tableb.name FROM tableb) ; UNION ; Select tableb.sales as total,tableb.name FROM tableb; WHERE NOT tableb.name in (Select tablea.name FROM tableA); into CURSOR tmp SELECT tablea.service+tableb.sales as TotalSalesService,tablea.name; FROM tablea INNER join tableb ON tablea.name = tableb.name; UNION; SELECT * FROM tmp; ORDER BY 2Regards,