Where clause on two relationships

Did you set up proper Eloquent relationships? Then check out Querying Relationship Existence.

// Retrieve all customers that have at least one booking...
$customersWithBookings = App\Customer::has('bookings')->get();

Think Relationships-

• A Customer has Many Inquiries
• An Inquiry has has one / many bookings (you decide)

Now echoing @m165437 answer-

// Retrieve all customers that have at least one booking... $customersWithBookings = App\Customer::has('bookings')->get();

Thanks guys, but i get a errormessage

BadMethodCallException Call to undefined method App\Customer::has()

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Customer extends Model
{
    public function inquiries() {
        return $this->hasMany(Inquiry::class);
    }
}

can't get bookings without going through inquiries first, since a booking belongs to an inquiry and not the customer (directly)

okay thanks, but this doesn't solve the problem because i still get a methodnotfound exception

I believe it's whereHas, not has https://laravel.com/api/5.5/Illuminate/Database/Eloquent/Concerns/QueriesRelationships.html#method_whereHas

no also the same error :(

help pls...