sql - Nanosql2 delete with join

Question

It's about nanoSQL 2 (https://nanosql.io).

I wish I delete all the rows from table B not in the table A.

For instance, having

table B: {id: 1, id: 2, id: 3, id: 4, id: 5}

table A: {id: 1, id: 2, id: 4}

After delete I wish to have:

table B: {id: 1, id: 2, id: 4 }

I tried something like the script below but is not working.

Is that possible? If so what do you suggest is better I do?

nSQL("table_B")
 .query("delete")
 .join({
        type: "inner",
        with: { table: "table_A" },
        on: ["table_B.id", "!=", "table_A.id"]
 })
.exec()

question from:https://stackoverflow.com/questions/66054401/nanosql2-delete-with-join

Answer 1

Waitting for answers