How to Query two tables in one query statement

You need to show your columns with some dummy data and explain what you need

on the jobs table

id |    client_id | job_title | job_desc
1        1         first job    blah blah
2        2             another  blah blah   
3        1         second   blah blah

on the applied job

id | developer_id | client_id | job_id | status
1       1               1        1            1

so i have something like this..

I want to show all the data on the jobs table where the status on the applied job isn't true(1)...

Assuming you have a hasMany relationship called appliedJob on the Job model...

$jobs = Job::with('appliedJob', function($query) {
    $query->where('status', '!=', 1);
})->get();

I get this error mb_strpos() expects parameter 1 to be string, object given

You'll need to show more code then besides just your schema. Like do you have a appliedJob relationship on the Job model? Show your Job model and AppliedJob model.

on the job model

public function job_applied(){
        return $this->hasMany('App\AppliedJob');
    }

on the appliedjob model

 public function job(){
        return $this->belongsTo('App\Job');
    }

Did you adjust the relationship name in my query to match yours? I used appliedJob, but your actual relationship name is job_applied

yes i did

Using with gives all jobs and joins applied jobs where status is 1

If you only want jobs where applied status is not 1

$jobs = Job::whereHas('job_applied', function($query) {
            $query->where('status', '!=', 1);
        })
        ->with('job_applied')
        ->get();

i get this error @Snapey Call to undefined method Illuminate\Database\Query\Builder::job_applied()

try

$jobs = Job::whereHas('jobApplied', function($query) {
            $query->where('status', '!=', 1);
        })
        ->with('jobApplied')
        ->get();

Call to undefined method Illuminate\Database\Query\Builder::jobApplied()

@Snapey

Do your relationships work in other places?

yes.. they do

so

php artisan tinker;

App\Job::with('job_applied')->first()

works ok?

it's working now... i had {{$jobs->links()}} in the view and the code didn't have paginate on it..

but now its bringing the jobs from the approved_jobs table only.. and not the whole jobs

what i'm trying to do is bring out the whole jobs which would include the ones in the applied_jobs table.. but then it would exclude the ones in the applied_jobs table where the status there is true.. therefore bringing out all the jobs that haven't been assigned true.. the job table doesn't have a status column..

i hope you understand what i'm trying to do

like assuming on the jobs table there are

1 - job 1
2 - job 2
3 - job 3
4 - job 4

then you apply for job 3 and job 4

so in the applied_jobs table you'd see

1 - job 3 
2 - job 4

then the person approves you for job 3

so now job 3 has a status of true

so i would want to get the results of all the jobs without that job 3, since it has been approved

so i'd get

job 1
job 2
job 4

hope i'm clear ?

What code are you using, mine or cronix

Please show your current code

yours

 $jobs = Job::whereHas('job_applied', function($query) {
            $query->where('status', '!=', '1');
        })->with('job_applied')
        ->get();

So, I expect that this should return all jobs with an applied job and the status is not 1

You want all the jobs, not just those with applied_job.status=1

There is no check here that the jobs relate to an individual?

$jobs = Job::whereDoesntHave('job_applied', function ($query) {
    $query->where('status', '!=', 1);
})->get();

Thank you so much @Snapey and others that tried