identify rows in 1 table not in another table

skyline01 — Tue, 26 Mar 2019 18:49:04 GMT

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?

Re: identify rows in 1 table not in another table

Vegar — Tue, 26 Mar 2019 19:09:27 GMT

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)
;

topic identify rows in 1 table not in another table in App Development

identify rows in 1 table not in another table

Re: identify rows in 1 table not in another table