MySQL Forums
Forum List  »  Newbie

Multiple table joins
Posted by: M
Date: April 15, 2005 02:29PM

Hello,

I'm having a horrible issue with MySQL 4.1

I have 10 tables, all identical structure, filled with flat files. I'm trying to grab all the data from the same column in each of the tables and am having no luck doing so. I'd like to select the DISTINCT data as well, but I'd rather get this out of the way before continuing on with that. My computer pretty much crashes once I submit this:

select table1.description
from table1, table2
where table1.ZIP = table2.ZIP;

Also tried

select table1.DESCRIPTION, table2.DESCRIPTION
from table1, table2;
_

the cursor then sits there and blinks.

Any help would be appreciated.

Thanks,
M

Options: ReplyQuote


Subject
Written By
Posted
Multiple table joins
M
April 15, 2005 02:29PM
May 01, 2005 06:11AM
May 01, 2005 10:41AM
May 01, 2005 11:02AM
May 01, 2005 12:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.