Find records in one table which are missing in another table

How do I find records in one table which are missing in another table; like a minus in sql

select id from table_1

minus

select ident from table_2

I have views created for both tables joined by full outer join in explore

Is there any way to get the missing records from table_2 without creating a derived_table?

0 0 133
0 REPLIES 0
Top Labels in this Space
Top Solution Authors