lundi 2 mai 2016

Convert mysql query in laravel5.0

I want to apply following query in my Laravel5.0 application

sql = "select c.User_ID, c.Name, c.Mobile_No from client as c where c.User_ID not in "
            + "(select b.User_ID from bill_history as b where "
            + "b.User_ID = c.User_ID )";

for the current month so that I can find the due users of month. What will be format of the above mentioned query in Laravel5.0?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire