How to convert my SQL Query to Query Builder in Laravel 5.8 ? This is my Query :
SELECT
COUNT(id) AS DATA
FROM
(
SELECT
id,
(
SELECT
COUNT(id_item)
FROM
project_item_deliveryorder
WHERE
id_item = project_item.id
) AS EXIST
FROM
project_item
WHERE
id_project_master = 1
) TBL_EXIST
WHERE
TBL_EXIST.EXIST = 0;
Thank you for helping me :)
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire