8000 how can i use `delete` with 'join' · Issue #117 · datavjs/sql-bricks · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
how can i use delete with 'join' #117
Open
@BugKun

Description

@BugKun

it like this

console.log(
    squel.delete()
    .from('a')
    .target('a')
    .join("b", null, 'a.test_id=b.test_id')
    .where(`b.user_id='1'`)
    .toString()
)
// DELETE a FROM a INNER JOIN b ON (a.test_id=b.test_id) WHERE (b.user_id='1')

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0