Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT
JOIN".
Thanks!
Mike Spreitzer
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
Why is it that a field name that works fine for a JOIN is invalid in a
STRAIGHT JOIN?
mysql> show create table fldsndm;
+-+--