Query to get difference between tables

[bcoates]

I have two tables that i joined by name in the relationship editor. I need to get all the records from table 2 where there is no match to table 1.


ex
TABLE 1
Name Description
tab_name tab_name descript1
tab_name tab_name descript2
tab_name2 tab_name descript3

TABLE 2
Name Description
tab_name tab2_name descript1
tab_name2 tab2_name descript2
tab2_name3 tab2_name descript3


I need tab2_name3 to be returned along with the description

Thanks

 

[Remou]

There is a Find Unmatched Query Wizard. You can select it by choosing Query from the drop-down on the toolbar.

 

[bcoates]

Brilltastic, thanks