Question

Find records in one table which are missing in another table

  • 23 November 2022
  • 0 replies
  • 4 views

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 replies

Be the first to reply!

Reply