mercredi 5 septembre 2018

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.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire