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

_NinjaDev's avatar

How to turn this into Query Builder?

This is my raw sql and i want to use this via query builder. Maybe anyone can help me?

SELECT da.id as da_id, da.client_id, pai.amount 
from deposit_accounts da 
left join 
	(select id,deposit_account_id, amount from posted_accrued_interests 
		where date(created_at) = CURDATE()
	) pai 
on da.id = pai.deposit_account_id 
where pai.id is null

Thanks.

0 likes
1 reply

Please or to participate in this conversation.