in reply to DBIx join problem
The two code snippets above only defines metadata for use to configure DBIx::Class. Where is the code where you try to query and fail?