is it possible to join two tables on a field and only pull in what is in the left table but not in the right, with in db, not static, join? i see how to do it with multiple static join but i'm not seeing how to do this with indb join.
thanks
becki kain
Solucionado! Ir para Solução.
In other words, you're using the join to filter the records you're getting back from the left table? If you use the Join In-DB tool, select Left Outer Join from the configuration pane, and then use the Select In-DB tool to remove the columns that are included from the right table, that should work.
yes, that worked as long as I put a indb filter for right hand column is null, matching this sql:
SELECT columns FROM TableA LEFT OUTER JOIN TableB ON A.columnName = B.columnName WHERE B.columnName IS NULL
This doesn't work when you are working from two different database servers. Alas!