Qual seria o mais eficiente ? SELECT A.CAMPOS FROM TABELA_A A LEFT JOIN TABELA_B B ON(B.CODIGO = A.CODIGO) WHERE (B.CAMPO IS NULL)
ou SELECT A.CAMPOS FROM TABEL_A A WHERE (A.CODIGO NOT IN(SELECT CODIGO FROM TABELA_B)) -- Marcelo Silva ---------------------------------------------------------------- Desenvolvedor Delphi / PHP My Postgres database Cel.: (11) 99693-4251
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
