who can help me? I was selected from sql. This is my sql. How to create with Laravel query in controller.
SELECT sp
.name_en, sp
.email, sp
.phone, post
.name
AS position_name
FROM staff_profiles
sp
INNER JOIN staff_positions
p
INNER JOIN positions
post
WHERE sp
.id=p
.staff_id
and p
.position_id
=post
.id
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire