Hi all:
I think what I want to do is join tables in a select statement but I'm not
having any luck.
I'm using MySQL 3.22 PHP and apache on RH6.2
I have an application that has multiple tables that customers upload order
data to. People who look at this data can see their orders from each table
individually. Now they want to download their data from each of these
tables into their own database.
When I do a select on my test table like:
Select * into outfile /home/temp/test.txt from apple where RepID = NYS I
get a file that is 150K.
When I do a select on 2 of my test tables(which are identical)like:
Select * into outfile /home/temp/test.txt from apple as t1, bass as t2 where
t1.RepID = 'NYS' and t2.RepID='NYS'
I get a file that is 116MB with each record being repeated 866 times. When I
do a left join it does about the same thing. I'm going to want to do this
with more than 2 tables so is my approach to this wrong or just my syntax.
I've read the manual page on join and (I admit it) I don't understand it.
Thanks for your help
willie
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
