Sarah Officer wrote:
How about using a union?
select cc.com_cat_long, co.company_name
from company_category cc, company co
where cc.com_cat_abbr = co.com_cat_abbr
union
select 'unknown' as com_cat_long, company_name
from company
where com_cat_abbr is null;
Yes, would be the best way
On Tue, 11 Jan 2000, Bruce Bantos wrote:
In my current Oracle DB, I have a number of "lookup" tables
that contain something like this:
You make a "lookup" function, and you call the
function in your select list.
It's been a few months since I've played with
PostgreSQL, so I don't