main logo
Subject: Re: DELETE FROM with subselect
Author: "Michael J. Babcock"
Posted: 2004/02/28 11:55:00
 
View Entire Thread
New Search


Brian Abbott wrote:

> Does this work?
>
> USE jobs
> DELETE FROM jobs WHERE nJobID in (select njobid FROM crap)

Nope! http://mbsoftwaresolutions.com/images/nope.JPG


--

Michael J. Babcock, MCP
President/CSA, MB Software Solutions, LLC
http://mbsoftwaresolutions.com
"Bettering your bottom line by helping you work smarter, not harder,
with custom software solutions."



 
©2004 Michael J. Babcock
<-- Prior Message New Search Next Message -->