Summary
In this chapter, we have covered a comprehensive list of SQL JOINs and how they can be expressed via the jOOQ DSL API. We started with the well-known INNER/OUTER/CROSS JOIN, continued with Implicit Joins, Self Joins, NATURAL and STRAIGHT JOINs, and ended with Semi/Anti Joins, CROSS APPLY, OUTER APPLY, and LATERAL Joins. Also, among others, we covered the USING clause and the amazing jOOQ onKey() method.
In the next chapter, we tackle the jOOQ types, converters, and bindings.
