Hi Bret, What version of Cake are you running? I had this issue when running MySQL 3.23. In the end, I just modified the Cake core code so that Cake included the 'INNER'.
Not an ideal solution, but it did solve the problem for MySQL 3.23 Regards, Langdon Bret Kuhns wrote: > I have the exact problem as in this topic: > http://groups.google.com/group/cake-php/browse_thread/thread/1522701f158e90b8/a25f475b8f5230ee?lnk=gst&q=habtm+JOIN+query+error&rnum=2#a25f475b8f5230ee --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---