Eloquent equivalent of inner join

@vrapan Yes, eloquent does it this way and no other.

You want query builder, no need for raw SQL, in order to do it. However, the question is, why would you want to pull all 10000 records at once?

@JarekTkaczyk the end result of the query is around 150 odd rows but to get all the data I want I need to join a couple tables together. The rows linked between the tables are quite a few. An inner join would work a where in would be not so great.

Thanks for the reply though at least I will not be hunting down a way to do this that does not exist.

@vrapan Then I suppose you didn't want a with, but rather has/whereHas. However it still might not be the best in this case.

just read up on those two and they are useful but I think in the end it is a bit more hassle than just query builder which is what I used. QB is a lot like SQL which I enjoy anyway!

You do realize of course there is no such thing as an eloquent query at all eloquent is a shortcut, at runtime everything is converted into real mysql queries anyway. And read this http://laravel.io/forum/05-12-2015-has-many-through-relationship-depth

Eloquent objects can use all query builder methods such as join:

$result = User
    ::join('contacts', 'users.id', '=', 'contacts.user_id')
    ->join('orders', 'users.id', '=', 'orders.user_id')
    ->select('users.id', 'contacts.phone', 'orders.price')
    ->getQuery() // Optional: downgrade to non-eloquent builder so we don't build invalid User objects.
    ->get();

I do this whenever ->with would create hundreds of related objects I don't care about -- huge performance difference.

@claar it's exactly what many people are searching for, Thanks and another one for using getQuery()!

joins with eloquent can be very tricky you can try with this package : https://github.com/fico7489/laravel-eloquent-join