Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 29 October 2013

Exists and IN operator to find Not present numbers in when compare two tables

Exists and IN operator to find Not present numbers in when compare two tables

There are two tables in db like student and course as see below:


Here u can see courseadmin column have no 8 is missing in Course Table when compared to Student table like studentid

Note:
(here Courseadmin is nothing but studentid who have studying course in course table)


So Hence to find not present no's when compare two tables

first put large table as first like up and low as second like below structures

student table(all value present table)

operator

course table(value missing table)

So, see below to find two methods