Re: STRAIGHT JOIN vs. field names

2010-08-11 Thread Mike Spreitzer
Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT JOIN". Thanks! Mike Spreitzer

Re: STRAIGHT JOIN vs. field names

2010-08-11 Thread Michael Dykman
The relationship looks righteous enough but I note that you use 'straight join' in your expression, rather than 'straight_join' as indicated in the manual (http://dev.mysql.com/doc/refman/5.1/en/join.html). Perhaps the message is a red herring and your trouble is elsewhere? - michael dykman On