User Id :    Password :      New Member   Forgot Password  
Topic: Write a query when we need a row that are not common between two tables ?
Anamika singh
11 Oct 2010 at 03:17 AM
Write a query when we need a row that are not common between two tables ?
Re: Write a query when we need a row that are not common between two tables ?
Gaurav
12 Oct 2010 at 03:14 AM

We use EXCEPT to do this
SELECT col1,col2,col3 FROM table1
EXCEPT
SELECT col1,col2,col3 FROM table2

Total Replies: 1
 
Featured Text Ad

Featured Ad