Posted - 09/08/2013 : 00:24:09
| Dear Friends in SQL,
I have two temporary tables, one a Master with the key columns as
subject name and
I have another transaction table where the main key column is subjectid
I want to extract only those subject id's which are not there in the transaction, but there in the master.
What is below is only a simplified version of my actual code, but it will serve the purpose.
SubjectId Subject Name
My select or code should give me the subjectids 01 and 03