http://qs1969.pair.com?node_id=187830


in reply to Merging SQL Results

If you are using Postgres, and you want to apply the logic, "when a field is null, return '--'", then using the COALESCE or CASE functions are a good solution for that. You can read more them here.

-mark