Syntax only. 

INNER JOIN table2 USING (id)
INNER JOIN table3 USING (id)

Equates to

table1.id = table2.id 
AND table2.id = table3.id; 


Regards,
Mike Hillyer
www.vbmysql.com


-----Original Message-----
From: Anthony Ward [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 05, 2003 12:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Join question


Hi,

what is the difference between your way and Mike Hillyer way?? (I can
see
the INNER join).

But thanx to both of you.

Anthony



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to