SELECT * from Table2 EXCEPT SELECT * FROM Table1

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 / newbie

4 Answers
8051 Views
I also Faced
E-Mail Answers

Answer Posted / newbie

SELECT * from Table2
EXCEPT
SELECT * FROM Table1

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are “unrepeatable reads”?

1176

How do I find the query plan in sql server?

907

What are the differences between user defined functions and stored procedures?

1004

What is dimension table? : sql server analysis services, ssas

969

How can we delete a table in sql server?

922

What are the different types of backups avaialabe in sql server 2005?

970

what is datawarehouse?

1052

What is hot add cpu in sql server 2008?

884

What is the difference between char, varchar and nvarchar?

978

How to create and drop temp table in sql server?

1002

What is buffer cash and log cache in sql server?

1054

Why can there be only one clustered index and not more than one?

930

What is a View ? Can we insert, Update and delete a view?

940

Explain what are magic tables in sql server?

947

What is the difference between deallocate cursor and close cursor?

1166