No duplicate query

[Guest_imported]

Hello,

I have two columns of numbers, each in a seperate table. One column is dynamic and the other is static. I need a query that will compare the numbers in each table and return the numbers from the dynamic column that aren't already in the static column.

Could anyone help with this?

Thanks in advance

Gary

 

[Cagliostro]

select dinamic_col from dinamic_table
where dinamic_col not in(select static_col from static_table) John Fill

ivfmd@mail.md