I’m trying to do a query that joins on 2 other tables, but I’ve noticed that the query generated is not valid:
SELECT Jobs.*, EducationLevels.description as education_levels_description, JobsCategories.*
FROM `jobs` AS `Jobs`
LEFT JOIN `education_levels` `EducationLevels` ON `Jobs`.`education_level_id` = `EducationLevels`.`education_level_id`
LEFT JOIN `jobs_categories` `JobsCategories` ON
WHERE ( `JobsCategories`.`category_id` = '3' AND `Jobs`.`is_published` = '1' )
Do you see the 2nd LEFT JOIN has an unqualified "ON" statement? What’s up with that? Did I define my relationships incorrectly?
My code is something like this:
$query = $my_xpdo->newQuery('Jobs');
$query->leftJoin('EducationLevels');
$query->leftJoin('JobsCategories');
$query->select( 'Jobs.*, EducationLevels.description as education_levels_description, JobsCategories.*' );
☆ A M B ☆