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) You may respond directly to me, if possible. Thank you. Kendra Knudtzon --------------------------------------------------------------------- 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
