On Tue, Dec 11, 2001 at 07:34:11PM -0800, Kendra L Knudtzon wrote:
> I am having problems with this nested inner join statement:
>
> SELECT tblMethodType.MethodType, tblMethodParm.MethodName,
> tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip
> FROM tblMethodType INNER JOIN (tblMethod INNER JOIN (tblParm INNER JOIN
> tblMethodParm
> ON tblParm.idParm = tblMethodParm.idParm) ON tblMethod.MethodName =
> tblMethodParm.MethodName) ON tblMethodType.MethodType =
> tblMethod.MethodType;
>
> I have not had much experience with INNER JOINS, and I read one website
> that said the MySql can't support grouped inner joins... If this is true,
> how do I get this type of command to execute under MySql (I inherited this
> code but the statement apparently worked with Microsoft Access)
MySQL supports grouped INNER JOINs just fine. But you can't put an
inner INNER JOIN between the outer INNER JOIN and the ON keyword.
Try
FROM (inner INNER JOIN clause) INNER JOIN tblMethodType ON ...
Do the same thing with the innermost INNER JOIN clause.
What you typed above works fine in Access because Access doesn't
care about the order.
Bob Hall
--
"Kanskje, kanskje en gang
- sier du til meg -
database, table, query" RolfJacobSQL
---------------------------------------------------------------------
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
