I have a quick question and hoping I don't need to provide data for this question.
I need to join two tables with multiple fields. What is the best efficient way of doing that?
select cn.*, cl.*
from
rpt_census_data cn
left outer join rpt_report_client cl on (cn.account_number = cl.account_number
and trim(cn.client_zip_code) = trim(cl.client_zip_code)
and trim(upper(cn.client_city)) = trim(upper(cl.client_city))
and trim(upper(cn.client_state)) = trim(upper(cl.client_state)))
Thanks in advance! Appreciate any quick feed back!