Delete Using join in min 3 tables

  • Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition

  • charit0819 (11/19/2012)


    Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition

    You need to write SQL queries using DELETE, FROM, JOIN and WHERE clauses.

    I guess you wanted a bit more details isn't it? But you question is too generic. You need to add some substance to it. Please read the article at the bottom of my signature to find out how to post such questions to this forum in order to get prompt and relevant replies.

    BTW, at first glance, haven't realised that it's your first post here, sorry...

    Welcome to the forum!

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • charit0819 (11/19/2012)


    Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition

    this link will give you couple of required examples http://www.simple-talk.com/sql/learn-sql-server/the-delete-statement-in-sql-server/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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