where not exist?

[ali_hijazi]

Hello

I got 2 tables table1 and table2 both have the column InvoiceKey

I made an inner join on both tables to get the common values of the invoiceKey (and the table is table3)

Now I want to extract the values of table1 that are not in table3 and also from table2 that are not in table 3

Please advise

[spividori · Accepted solution]

He.

See the example.

Regards.

[Anonymous]

Very helpful!  Thank you.

[giuval45]

Hi Sandro,

it has been very useful also for me...;-)

Many thanks,

Giulio