Results 1 to 2 of 2

Thread: How can I do a subquery delete

  1. #1
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,230

    How can I do a subquery delete

    Hi,

    I need to delete rows from table a that exists in table b.

    Delete from a where col1 in (select col1 from b).

    I have tried an inner join delete, but Lianja is not happy with that.

    I could do a scan, but wanted to do this via a statement.

    What is the Lianja equivalent?

    Thanks

    Herb

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,972
    Hi Herb,

    try this...

    Delete from a where sqlLookup(“b”, “col1”, col1, “true”, “false”)



    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us