William Martell wrote: >rice and on hand quantity from these three tables. Each part number is >the same in all three tables. The other fields are different. I would like >to display each tables data sorted by item number. I am having trouble with >my select statement. > > SQL: select * from t1, t2, t3 where t1.partnum = t2.partnum and t1.partnum = t3.partnum;
I highly suggest reworking your data structures at some point in the future though. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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
