Re: Re: select to combine 2 tables - Mailing list pgsql-general

"Thomas T. Thai" <tom@minnesota.com> writes:
>> Use a union query:
>>
>> select rec_id, path, '' as link, name from cat_cat
>> UNION
>> select rec_id, path, link, name from cat_alias

> there is no way to do this in a generic DBI way? i need for this to work
> across diff kind of DBs.

Huh?  That *is* the generic, fully-SQL-standard way.

            regards, tom lane