question

Adnan183 avatar image
Adnan183 asked

query to get unmatched data from two tables in sql

i have two tables named table-1 "Census" which have columns like "Emiscode,School_name,Uc_name" and table-2 "School_info" which have columns like "Emiscode,school_name,inspect_Date,uc_name" table-1 fields are permanent table-2 fields are updates for every month for example table-1 have 100 records and table-2 have 70 records for the month of january 2013 i want unmatched 30 records from table-1 those not update/inspected in the month of January 2013
sql-server-2000
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SSGC avatar image
SSGC answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.