Select Non-Matching records from two tables 1

[ajharn]

Linking selects records from two tables where there are matching values in the linked fields. This works well for me.

What I can wrap my head around is this:

Table 1 and Table 2 (different DBs) both have an indexed field (JobNumber).

I want to select records in Table 1, when NO matching record exists in Table 2.

Any help appreciated. I'm fairly new at this, so please forgive dumb questions. Research of the documentation and this forum have not bridged the gap.

Thanks,
AJ

 

[lbass]

Use a left join FROM table1 TO table2 and then use a record selection formula like:

isnull({table2.jobnumber})

-LB

 

[ajharn]

Yup. That did the trick.

Thanks for a quick and spot on response.

Cheers,
AJ