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?