Hi out there!
We are converting our old access database to MySql, about time!
we are experiencing some problems with "double nested joins", don't know
what else to call them.
the query in access looks something like this:
SELECT arrangement.Navn, arrangement.StartDato, arrangement.SlutDato,
ar
I am having similar nested join problems with the following:
SELECT tblThread.Message_date, tblAuthor.Username, tblAuthor.Author_ID,
tblTopic.Forum_ID FROM (tblForum INNER JOIN tblTopic ON tblForum.Forum_ID =
tblTopic.Forum_ID) INNER JOIN (tblAuthor INNER JOIN tblThread ON
tblAuthor.Author_ID = t
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 JO
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
