Search code examples
joinsubquerymybatisdynamic-sql

MyBatis Dynamic SQL join on subquery

I want to do something like this in MyBatis Dynamic SQL:

SELECT id FROM foo
JOIN (SELECT foo_id ...) bar ON foo.id = bar.foo_id
WHERE ...

However, the join() function only accepts SqlTable as an argument.

Is it possible to join on a subquery with MyBatis Dynamic SQL? If so, how do I do it?

Solution

  • MyBatis Dynamic SQL doesn't support these types of sub-queries right now. I'll think about adding it.