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 Query Expand / Collapse
Author
Message
Posted Wednesday, September 15, 2010 2:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:07 PM
Points: 39, Visits: 187
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
Post #986691
Posted Wednesday, September 15, 2010 2:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:44 AM
Points: 6,236, Visits: 7,380
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #986698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse