>hi Garrett,
>
>You used these code
>
>FROM mhngroup!groupname ;
>LEFT OUTER JOIN mhngroup!group ON Groupname.namekey = Group.namekey ;
>LEFT OUTER JOIN mhngroup!groupnum ON Groupnum.numkey = Group.numkey ;
>LEFT OUTER JOIN mhngroup!notedata ON Notedata.groupkeyid = Group.groupkey
>
>istead of these code
>
>FROM mhngroup!groupname LEFT OUTER JOIN mhngroup!group;
>LEFT OUTER JOIN mhngroup!groupnum;
>LEFT OUTER JOIN mhngroup!notedata ;
>ON Notedata.groupkeyid = Group.groupkey ;
>ON Groupnum.numkey = Group.numkey ;
>ON Groupname.namekey = Group.namekey;
>
>Why do you want t change this?
Because it's parsed from the inside out. The beginning of the parsing reads like
groupnum JOIN noteData ON notedata.groupKeyId = group.groupKey
, which is why the error gets thrown. Writing it "sequentially" instead of "nested" eliminates this problem, and makes it a bit easily to follow, IMO.