I have a problem with a COALESCE function. The query is as followed:
SELECT CASE when branches.Location_code is null then 'error site'
else active.Location_code end as Location_code, active.Workstation_id
, active.Last_logged, active.report_date FROM active
LEFT OUTER JOIN branches ON active.Location_code = branches.Location_code
AND branches.Deleted_branches = '0'
I would like to add three more columns from the table branches to the view. Branch name, Type site and Status. And this information should be shown with every row listed in the view.
But itís not working. So far I managed to show those three columns only when the Location code from both tables are matching. Is it possible
to show this information for every row in the view?