Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Delete Using join in min 3 tables Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 1:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 1:22 AM
Points: 1, Visits: 0
Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition
Post #1386199
Posted Monday, November 19, 2012 5:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 2,858, Visits: 5,132
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!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1386315
Posted Monday, November 19, 2012 11:01 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1386686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse