[Dbix-class] New user with JOIN problem

[Chris Cole]

Matt S Trout wrote:
> On Wed, May 13, 2009 at 03:18:20PM +0100, Chris Cole wrote:
>>> Then we can make a start at helping you - currently your database is too
>>> broken.
>> That's what's confusing me. How come the SQL works fine?
> 
> MyISAM == broken, unless you -really- know what you're doing. No foreign
> key support, no rollback in transactions, etc.
> 
> Bad. Wrong. No. Don't do it.
> 

Except, the tables are InnoDB.