Multiple joins in the same query

[bondcs]

Hi

Is possible?

Thanks you

[only-cliches]

Not yet, but this should be pretty easy to add.

I'll put this in the next update.

[only-cliches]

Just pushed v1.5.5 with multiple join support.

Just pass an array of join arguments into .join(), like this:

nSQL("users").query("select").join([
    {
        type: "inner",
        table: "posts",
        where: ["users.id", "=", "posts.author"]
    },
    {
        type: "inner",
        table: "comments",
        where: ["users.id", "=", "comments.author"]
    }
]).exec()...

Let me know if that works as expected!

[bondcs]

Worked perfectly.

Thank you for the rapid development.

[only-cliches]

Sweet 😄 Marking this one resolved.