Ways to create Join

[augustoccesar]

A Join should be created in one of the many ways:

new Join(Join.LEFT).table("user_profile{up}").on("{u}id", "{up}user_id");

new Join(Join.LEFT).table("user_profile{up}").on("{u}id = {up}user_id");

new Join(Join.INNER, "user_profile{up}", "{u}id", "{up}user_id" )

new Join(Join.INNER, "user_profile{up}", "{u}id = {up}user_id" )

[augustoccesar]

And SelectBuilder should contain methods to easy the way of creating joins like:

new SelectBuilder().innerJoin("user_profile{up}", "{u}id", "{up}user_id")
new SelectBuilder().leftJoin("user_profile{up}", "{u}id", "{up}user_id")
new SelectBuilder().rightJoin("user_profile{up}", "{u}id", "{up}user_id")
(...)

[augustoccesar]

Maybe Join should have a method for easy build like in SelectBuilder, like:

Join.innerJoin("user_profile{up}", "{u}id", "{up}user_id")

instead of having to instantiate a new Join object using new