Please help me.
I have two tables.
First table has rows with some colums
Second table has rows with same colums and some other columns

I need to get rows that exist in table one but not in table two.
Please see the picture

I could not upload picture

http://www.techonthenet.com/sql/joins.php

Please review the following link. This might help you for future reference too.

This really depends on the Relation between two tables. This could be the syntax for two tables containing same column say student_Id.

select *
from table one
where tableone.student_Id NOT IN
( Select tabletwo.student_ID
from table two) ;

Left Join

mvc,
That's not the proper way to do it. I know it works. But SQL query is not optimized in that Sub-query...............

Here it is

Select [Column lists...............]
FROM table1 a
LEFT JOIN table2 b
ON a.SameColumnName = b.SameColumnName
WHERE b.SameColumnName IS NULL

Thank you all.