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
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 records from
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 tables together, then do a select
='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 change the table names in the SQL I sent
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 change the table names in the SQL I
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
To: 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 merged table