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
>
sage-
From: Jessica Tishmack [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 2:53 PM
To: [EMAIL PROTECTED]
Subject: multiple tables with same fields
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
> 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
