Delete Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Delete Query

Delete Query

Rate Topic

Display Mode

Topic Options

Author

Message

JakDBA

Posted Wednesday, September 15, 2010 2:33 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:11 AM
Points: 38, Visits: 165

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

Evil Kraig F

Posted Wednesday, September 15, 2010 2:38 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:35 PM
Points: 5,722, Visits: 6,194

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 »

Permissions