When column is null compare two columns
I'm having a problem with the next query
select b.street_name
from family a, address b,adress2 c
where a.id_family=b.id_family
and a.id_famiy=c.id_family
The problem that I have is that but some ilogical reason, there are 2
tables with adresses, so when b.street address is '' or null, i would like
to compare from address another field that is called cve_col which is also
on address2 which contains the name of the street.
No comments:
Post a Comment