These two statements say the same thing. They shouldn't cause a problem but
the probably don't do what you want.
Try using the first table multiple times and use an alias.
Don't have my book handy but it seems to me that :
Select table1.*, table2.* from table1 as t1, table1 as t11, table 2 as t2
where t1.blah = t11.blah and t1.blah = t2.blah;
Or something to that effect.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
----- Original Message -----
From: "Nick Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 08:02
Subject: many to many join on 2 tables.
>
> Hi,
>
> I'm have a bit of difficulty with a many to many join on two
> tables. (Where an item is directly related to another item of the same
> type in the same table).
>
> I'm trying to use the same method as a join between 2 tables with
> a 3rd but having no joy. Help :)
>
> eg.
>
> table1.attb1 = table2.attb1 AND
> table1.attb2 = table2.attb1;
>
> Thanks.
>
> Nick.
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
