Try this....
If something is numeric....
SELECT * FROM table1, table2, table3, table4, table5, table6
WHERE table1.something = table2.something
AND
table1.something = table3.something
AND
table1.something = table4.something
AND
table1.something = table5.something
AND
table1.something = table6.something
;
If something isn't numeric.....
SELECT * FROM table1, table2, table3, table4, table5, table6
WHERE table1.something LIKE table2.something
AND
table1.something LIKE table3.something
AND
table1.something LIKE table4.something
AND
table1.something LIKE table5.something
AND
table1.something LIKE table6.something
;
----( Nick Pasich )----
On Mon, Apr 25, 2005 at 12:51:53AM +0200, Schalk Neethling wrote:
> Greetings everyone.
>
> Hope someone can give me some pointers here. I have six tables in the
> database and I need to JOIN them on a row that appears in all of the
> tables. How do I do this? I have so far done the normal 'cross-join'
> saying SELECT * FROM table1, table2, table3, table4, table5, table6
> WHERE something = something;
>
> I have also added STRAIGHT_JOIN to force the order but, how do I JOIN
> six tables to/by one column? I have done some google searches as well as
> looked at MySQL 2nd edition by Paul DuBois, sorry if I missed something
> here Paul, and so far I have not found an answer. Any help or pointers
> will be appreciated. Thank you.
>
> --
> Kind Regards
> Schalk Neethling
> Web Developer.Designer.Programmer.President
> Volume4.Business.Solution.Developers
> emotionalize.conceptualize.visualize.realize
> Landlines
> Tel: +27125468436
> Fax: +27125468436
> Web
> email:[EMAIL PROTECTED]
> Global: www.volume4.com
> Messenger
> Yahoo!: v_olume4
> AOL: v0lume4
> MSN: [EMAIL PROTECTED]
>
> We support OpenSource
> Get Firefox!- The browser reloaded -
> http://www.mozilla.org/products/firefox/
>
> This message contains information that is considered to be sensitive or
> confidential and may not be forwarded or disclosed to any other party
> without the permission of the sender. If you received this message in
> error, please notify me immediately so that I can correct and delete the
> original email. Thank you.
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
