mercredi 22 novembre 2017

laravel where not in

this is my mysql code

SELECT name,lastname FROM employee WHERE employee.id_employee
NOT IN (SELECT assistancea.id_employee FROM assistance WHERE assistance.id_meeting=3)

where I'm waiting for a value in number 3
3 is the id_meeting of meeting

table employe  
|id_employe|name|lastname

table assistance  
|id_employe|id_meetign|

table meeting  
|id_metting|description|date

You could help me make a query from laravel



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire