Is it possible to make a join by condition?

[RomanOrlovDev]

Hi, there,

sorry, probably this is a nut question, but can not figure out how to proceed.

Is it possible to make a join by condition?

e.g. (see comment)

func main() {
    db, _ := sql.Open("postgres", "postgres://username:password@localhost/database")
    stmt := postgres.SELECT(Actor.ActorID).FROM(Actor)
    if someCondition {
       // is it possible to JOIN another table to Actor here?
    }
}

[houten11]

Yeah, it is possible:

    var source ReadableTable = Actor

    if someCondition {
       source = source.LEFT_JOIN(ActorInfo, ActorInfo.ActorID.EQ(Actor.ActorID))
    }

    stmt := postgres.SELECT(Actor.ActorID).FROM(source)

You'd probably need to select columns dynamically also.

[RomanOrlovDev]

Thank you 🙏