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
> >
> >
> > Perhaps you want
: David Felio
Cc: [EMAIL PROTECTED]
Subject: Re: multiple tables with same fields
> 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
> 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.mysql.com/doc/M/E/MERGE.html
Th
sa' union select * from pets2 where
owner='lisa';
Jon Gardiner.
-Original Message-
From: Chris Blessing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 1:05 PM
To: Jessica Tishmack; [EMAIL PROTECTED]
Subject: RE: multiple tables with same fields
Same thing sti
elect * from pets2 where
owner='lisa';
Jon Gardiner.
-Original Message-
From: Chris Blessing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 1:05 PM
To: Jessica Tishmack; [EMAIL PROTECTED]
Subject: RE: multiple tables with same fields
Same thing still applies, just
Same thing still applies, just change the table names in the SQL I sent
earlier.
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: Re: multiple tables with same fields
> table pets1
>
You can use the table.field notation like:
select * from cats, dogs where cats.owner = 'lisa' || dogs.owner = 'lisa';
select cats.food, dogs.owner from cats, dogs;
etc. etc.
(note: '||' is the "or" logical operand)
Good luck!
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL
> 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
