daveWid/Peyote — pull request #5 by cbulock (2013-04-29 15:21:49+00:00)
Title: Multiple joins seperated by commas

$query = new \Peyote\Select('resources');
$query->columns('tag_list.name, basename, uid')
->join('tag_list', 'inner')
->on('tag_list.id', '=', 'resources.value')
->join('images', 'inner')
->on('images.uid', '=', 'resources.image')
->where($search_by, '=', $value)
->where('resources.type', '=', 'tag');
echo $query->compile();
//SELECT tag_list.name, basename, uid FROM resources inner JOIN tag_list ON tag_list.id = resources.value, inner JOIN images ON image.uid = resources.image WHERE image = ? AND resources.type = ?

The joins are comma separated. In MySQL, this gives a syntax error.