I'm new to Sumo.
I have 2 _searchCategories which have ids in common (with completely different data).
I have a query which returns ids from _sourceCategory1, something like
Now I need to search in another _searchCategory but only show result where id="id from query 1".
Could anyone give me direction how to do that?
Docs says I can't use subqueries in "where". I was looking into join as well but this will produce result from both queries while I only need results from second query but filter by field values from first query.
Effectively, I need an equivalent of
SELECT * FROM tbl WHERE id in (SELECT id FROM tbl2 WHERE field2=value2)
Thanks in advance.
Please sign in to leave a comment.