Re: [GENERAL] Re: select to combine 2 tables

"Thomas T. Thai" <[EMAIL PROTECTED]> writes: > On Fri, 22 Jun 2001, Tom Lane wrote: > > > "Thomas T. Thai" <[EMAIL PROTECTED]> 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 >

Re: [GENERAL] Re: select to combine 2 tables

On Fri, 22 Jun 2001, Tom Lane wrote: > "Thomas T. Thai" <[EMAIL PROTECTED]> 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 f

Re: [GENERAL] Re: select to combine 2 tables

"Thomas T. Thai" <[EMAIL PROTECTED]> 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

[GENERAL] Re: select to combine 2 tables

On Fri, 22 Jun 2001 [EMAIL PROTECTED] wrote: > > > 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. > > Notice