Como usar o comando EXISTS no SELECT?

Question

Preciso selecionar os valores da tabela1 mas que nao existam na tabela2....

Afarias · Accepted Answer

select * from tabela1 t1 where not exists (select 1 from tabela2 t2 where t2.valor = t1.valor)T+...

Billy · Answer

[quote:a267757864=�afarias�]select * from tabela1 t1 where not exists (select 1 from tabela2 t2 where t2.valor = t1.valor)T+[/quote:a267757864]...

F�rum Como usar o comando EXISTS no SELECT? #40272