hi, how to match retrieve the unmatched records from 2 tables in which we d

hi,

how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.

Question Posted / saroj

4 Answers
8249 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary..

Answer / gangadhar

select * from table2 where id not in ( select id from
table1)

Is This Answer Correct ?

18 Yes

0 No

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary..

Answer / debi

(select * from table2)
minus
(select * from table1)

Is This Answer Correct ?

6 Yes

6 No

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary..

Answer / newbie

SELECT * from Table2
EXCEPT
SELECT * FROM Table1

Is This Answer Correct ?

1 Yes

1 No

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary..

Answer / madhu sudhan g

Hiii

Its very simple to get the records that doesn't match lets
table1 is No1 and having A column values 1,2,3,4,5 and Table2
is No2 having column B values 1,2,3,4,5,6,7,8,9,10
Now Query is

select B from NO2 where B NOT IN(select A from NO1)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer