JOINING TO DELETE  
Author Message
yaroguy





PostPosted: Wed Jul 21 05:21:03 CDT 2004 Top

SQL Server Developer >> JOINING TO DELETE

Can someone please tell me what I'm doing wrong with this statement!

Thanks!


..:: CODE
CREATE PROCEDURE PageDelete
(
@ID Int

)
AS

DELETE FROM tblOfficePageContent
FROM tblPageContent P
INNER JOIN tblOfficePageContent O
ON P pageID = O pageID


SQL Server72  
 
 
raghava





PostPosted: Wed Jul 21 05:21:03 CDT 2004 Top

SQL Server Developer >> JOINING TO DELETE CREATE PROCEDURE PageDelete
( @ID Int )
AS
DELETE tblOfficePageContent
FROM tblPageContent P
INNER JOIN tblOfficePageContent O
ON P. pageID = O. pageID




> Can someone please tell me what I'm doing wrong with this statement!
>
> Thanks!
>
>
> ..:: CODE
> CREATE PROCEDURE PageDelete
> (

>
> )
> AS
>
> DELETE FROM tblOfficePageContent
> FROM tblPageContent P
> INNER JOIN tblOfficePageContent O
> ON P pageID = O pageID

 
 
David





PostPosted: Wed Jul 21 09:10:55 CDT 2004 Top

SQL Server Developer >> JOINING TO DELETE DELETE FROM tblOfficePageContent
WHERE EXISTS
(SELECT *
FROM tblPageContent P
WHERE pageid = tblOfficePageContent.pageid)


--
David Portas
SQL Server MVP
--