SQL join statement??

[mshen]

I have two table in MySQL .they have same structure.they have id,number and text.but table2 have more records than table1. I use the SQL statemant I can see the data that exist in two table.

select tab.number, tab.text, tab1.number, tab1.test
from table1 tab, table2 tab1
where tab.id = tab1.id

but now I want to see the data that only exist in table2 but not in table1.please let me know how to write the SQL statement.

Thanks a lot.

[Wien]

very quickly, maybe the order table1 join table2 is not correct

select tab.number, tab.text, tab1.number, tab1.test
from table1 as tab LEFT JOIN table2 as tab1 ON tab.id = tab1.id
where tab.id IS NULL