I know I've seen this but can't even begin to guess where that was so I'll
ask. I need to add a fake entry to a UNION. A row that doesn't exist in
the table and shouldn't. It's for a CGI script where I want the user have
the all/none/whatever option.
select tbl_key, equipname from equipment
UNION
select 'All', 'All Equipment' from ???
Heck I can't even remember what is was called in Oracle.
TIA,
Rod
--
Roderick A. Anderson
raanders@altoplanos.net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814