Ajuda com left join
Boa tarde
Estou a tentar fazer o left join com duas tabelas:
select a.a1, a.a2, b.b1
from tabela_a a
LEFT JOIN b ON b.b1 = a.a1
No entanto, quando a1 e b1 têm o valor zero, os respectivos registos não aparecem.
Os campos a1 e b1 são integer.
Alguem tem alguma dica para eu tentar resolver este problema.
Obrigada.
Natália Botica
Subject
Views
Written By
Posted
Ajuda com left join
3368
August 01, 2013 08:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.