Exclusive Query

From: Tarang (Tarang_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 16:47:14 -0700

I want a query that will give me all rows that are in one table but not in
another.
For example:

Table1.ID Table2.ID Result.ID
1 1 4
2 2 5
3 3 6
4
5
6

Thanks