Delete Query

  • Hi please help me out,

    i need to delete data Fetched from Table1 by selecting from below query

    select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA'

    Somthing like

    Delete fomr Table1 where select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA'

    please help me out..

    URGENT

    @JayMunnangi

  • Post repeat, please see question/responses here: http://www.sqlservercentral.com/Forums/Topic986689-145-1.aspx


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply