identify rows in 1 table not in another table

[skyline01]

I have the following 2 tables:

Table1:
Load * Inline [
ID1
1
2
3
4
5
]
;

Table2:
Load * Inline [
ID2
1
2
3
]
;

I want to create a third table that has all rows from table 1 that are not in table 2.  (ID1 and ID2 are the same attribute.  I just labeled them uniquely in case it matters.)  How can I achieve this?

[Vegar · Accepted solution]

Table1:
Load * Inline [
ID1
1
2
3
4
5
];

Table2:
Load * Inline [
ID2
1
2
3
]
;

Table3:
Load
ID1 as ID3
Resident Table1
WHERE
NOT EXISTS(ID2, ID1)
;