Finding Fields in one datasource that are not in another 2

[racskelly]

I have two datasources related by a common trade_num field...


i want to find all of the trade_nums in datasource A that are not in datasource B...

how do I join those two tables.. I tried inner join - not enforced - != but it didn't work...

any ideas?

Thanks

Shane

 

[Turkbear]

Hi,
If your connection type and datasource allow it, use a Command instead of the tables themselves..:
Try

Select trade_num from TableA
MINUS
Select trade_num from tableB

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Do a left outer join from tableA to tableB, then in the Report->Record Seletion->Formula place:

isnull({tableB.id})

Now you get everything in A not in B.

-k

 

[racskelly]

brilliant...thanks!