Editor and join

yurispy

In my script I can't use a left join.
because the table on the left is much too large compared to the called table.
Left table: 13976 records
main table: 184 records
What I need is an inner joint, but I don't know how to put it in place...

Someone might be able to give me some leads.
Thank you

rf1234

You can use a left join and check the key of the joined table to be "NOT NULL" (or one of the key components of a link table). That is the same as an inner join.

https://datatables.net/forums/discussion/comment/132045/#Comment_132045

In this example I need to make sure the rfp is approved. This requires an inner join not a left join:

.......
->leftJoin( 'rfp_has_govdept_approval', 'rfp.id', '=', 'rfp_has_govdept_approval.rfp_id')    
......
//rfp is approved (where clause needed due to left join!)
$q ->where(function ($r) {
    $r ->where( 'rfp_has_govdept_approval.rfp_id', null, '!=' );
});