Replies

• rf1234 Posts: 2,806Questions: 85Answers: 406

  March 2020 edited March 2020

  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, '!=' );
  });