We have a small ref data table called REFCODES (refid number primary key, created_date date not null). I have left out the other fields because it's not important. We use the REFID in the code, not the names, so don't need the other columns.
We have 2 copies of this, one in DEV and other other in TST.
We want to do a comparison between DEV and TST and see if there are any missing that were created in DEV in the last 6 months.
I have a copy of TST table in my development environment called REFCODES_TST.
How can we created the SQL??
We need the REFIDs in DEV which are not in TST which was created in DEV in the last 6 months.
It's a bit tricky, not straight ward.