G
Guest
Hai friends
I have a problem in writing query for composite primary key.
Problem -
1) clientid and dpid is composite primary ke
2) Master table has clientid and dpi
3) The new data i.e. Temp table (my temporary table) will also have the columns clientid and dpi
now I require a query to find the clientid's who are existing in Master table and not in Temp table
Thank you
I have a problem in writing query for composite primary key.
Problem -
1) clientid and dpid is composite primary ke
2) Master table has clientid and dpi
3) The new data i.e. Temp table (my temporary table) will also have the columns clientid and dpi
now I require a query to find the clientid's who are existing in Master table and not in Temp table
Thank you