On Thu, 18 Oct 2001, Jessica Tishmack wrote:
> > Jessica Tishmack wrote:
> > Basically, I want to merge two tables together, then do a select on the
> > resulting table. But I want to do this without having to actually create
> > a new merged table
>
> Jessica Tishmack wrote:
> Basically, I want to merge two tables together, then do a select on the
> resulting table. But I want to do this without having to actually create
> a new merged table
>
>
> Perhaps you want a MERGE table?
> http://www.mysq
> table pets1
> name foodowner
> fluffypurina kim
> fido kibbles lisa
>
>
> table pets2
> name foodowner
> snowy meowmix cheryl
> whiskers 9lives lisa
>
>
> Then I want to select all r
Is there a way to select records from multiple tables that have the same
fields, without doing a join?
Basically, I want to merge two tables together, then do a select on the
resulting table. But I want to do this without having to actually create
a new merged table. Example:
table pets1
nam
