Forum How to combine a join with a where clause?

posted 10 years ago

So I'm doing something like this:

$ImageCategory					= ImageCategory::where('styles.id', '=', $category->id)
																->leftJoin('images', 'styles.id', 'images.style_id')
																->get();

And I've also tried this:

$ImageCategory					= ImageCategory::leftJoin('images', 'id', 'images.style_id')->find($category->id);

Both return errors as invalid query syntax. Should work. Must I use a raw query for this to work or is there a more "eloquent" way of doing it?

Last updated 2 years ago.

davidlanier

replied 10 years ago

Oh duh! Stupid typo. Should be:

$ImageCategory                  = ImageCategory::where('styles.id', '=', $category->id)
                                                                ->leftJoin('images', 'styles.id', '=', 'images.style_id')
                                                                ->get();

Last updated 2 years ago.