MSSQL

  To give it a try, run the following script: 1 2 3 4 USE BookStore SELECT id , name , category , price FROM Books1 Except SELECT id , name , category , price FROM Books2 Here is the output of the above script:

 Best way to compare to tables and not have problems... LEFT JOIN Other if you use inner join the data is going to to joined;-)