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.
Answer Posted / gangadhar
select * from table2 where id not in ( select id from
table1)
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
what's the maximum size of a row? : Sql server database administration
What is the stuff?
What is self join in sql server joins?
What are the types of user defined functions in sql server?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How do I setup a sql server database?
What is the native system stored procedure to execute a command against all databases?
Explain left outer join and right outer join?
What is difference between inner join and join?
What is normalization process?
What happens if null values are involved in datetime operations?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are commonly used odbc functions in php?
Explain the architecture of ms sql reporting service?
User wants only to display only pdf as export option in report manager. How to achieve this?