Closed
Description
Currently I need to build a subquery statement which mysql. I want to build a sql like this
select * from (
select a.id, group_concat(b.id) as b_ids
from a left join b on a.id = b.aid
where SOME_STATEMENTS group by a.id
) c where find_in_set(sone_b_id1, c.b_ids) !=0 and find_in_set(sone_b_id2 c.b_ids) != 0
And currently subQuery only supported in where clauses
Metadata
Metadata
Assignees
Labels
No labels