CODEWITHSUNDEEP
laravel
jane
jane

Reputation: 25

How to get the matching data from two tables?

I'm used to compare 2 data, one data has an id and the other data is the one that needs comparing to get the matching datas. see code below.

DB::table('requests')->where('reqItem',$inventory->invItem)->get();

The code shown above displays all requests information that equals to the compared inventory item.

Now what i want to do now is to compare 2 tables without any id (ex. $inventory->invItem). I don't know how to ask this question but i hope you get what i mean. The figure below shows the way i wanted it to be.

enter image description here

Upvotes: 0

Views: 639

Answers (1)

msbomrel
msbomrel

Reputation: 519

You can run this query. Here, 'inventory' is the name of second table (change it accordingly)

DB::table('requests')
        ->join('inventory', 'requests.reqItem', '=', 'inventory.invItem')
        ->select('inventory.reqItem')
        ->get();

Upvotes: 2

Related Questions