Laravel 4 - Select rows where count of rows in joined table greater than 0

Question

I need to grab rows of

user

s where rows of

item

s exist. Here is my code so far:

$users = DB::table('users')

    ->join('orders', 'orders.user_id', '=', 'users.id')

    ->join('items', 'items.user_id', '=', 'users.id');

How do I add a where condition that will only select

user

s that have at least one

item

?

Answer 1

You don't have to add an extra condition. The query will return results ONLY for the users you have orders and items related with. If you want to return only the users that have items related with, you can drop the join with the orders table (even though I have no idea why you would have user_id in the items table instead of in the orders table).

$users = DB::table('users')->join('items', 'items.user_id', '=', 'users.id');

Laravel 4 - Select rows where count of rows in joined table greater than 0

Sign up