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
SQL Server Developer >> JOINING TO DELETE
DELETE FROM tblOfficePageContent
WHERE EXISTS
(SELECT *
FROM tblPageContent P
WHERE pageid = tblOfficePageContent.pageid)