Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

refib46918's avatar

Convert join SQL to Laravel PDO?

How convert this SQL to Laravel PDO?

SELECT * 
FROM ( SELECT SUM(amount) as deposits FROM transactions WHERE type_id = 0) AS A
JOIN ( SELECT SUM(amount) as withdraws FROM transactions WHERE type_id = 1) AS B
ON deposits > withdraws
0 likes
1 reply
gych's avatar

You mean like this?

DB::select("
    SELECT * 
    FROM ( SELECT SUM(amount) as deposits FROM transactions WHERE type_id = 0) AS A
    JOIN ( SELECT SUM(amount) as withdraws FROM transactions WHERE type_id = 1) AS B
    ON deposits > withdraws
");

Please or to participate in this conversation.