search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.83k stars 1.15k forks source link

nested query or sub query #712

Closed classix16 closed 6 years ago

classix16 commented 6 years ago

i have query:

select a., b.is_send from tbla as a left join (select from tblb were sts = 1) as b on a.id=b.id_a where a.num > 10

how do i use medoo?

i dont want raw function. becouse my app have potential change database from mysql to posgrees or oracle

catfan commented 6 years ago

Sub query will be more complex for Medoo in current. I suggest just use raw function or separate into two function call for this case.