菜鸟求教一个SQL问题。。

Question

表T1中字段id                                    表T2中字段id
1                                                    1
2                                                    2 
3                                                    3
4                                                    4
5                                                    5
6                                                    6
7
8
9
查询两个表中不同的ID...应该怎么写啊....  

Answer 1

select T1.ID from T1 where T1.ID not in(select T2.ID from T2)

Answer 2

select id from table where id not in (select id from table2)