How to select all the values from a table except the values which are in foreign table?

I have three tables:tbl_borrower, tbl_client and tbl_guarantor tbl_Client: id|name|address|email|

tbl_Guarantor: id|clientid(fk)|Guaranteed_date|borrower_id(fk from borrower table)

I want to retrieve all the values of client table except the values which are present in guarantor table in the controller of laravel 5.5.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2NQdw7d
via IFTTT