Question

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?

This topic has been closed for comments

Sign up