Hi Can you advise on how the following sql can be performed in tMap select FieldA from TableB where FieldA not in (select FieldA from TableB) At the moment I have a tSybaseInput for TableA and a tFileInputDelimited for TableB. Cheers
Where is your TableA in your query ? if TableA is such as : select FieldA from TableA where FieldA not in (select FieldA from TableB) Use a tMap and set your TableA as main table of the tMap (the first), and set your TableB as lookup (the second). Then set check INNER JOIN on lookup and check filter INNER JOIN in your output. Then connect your TableA.FieldA to your TableB.FieldA. To see more about the tMap, read the documentation. It should work like that.