CREATE TABLE [dbo].[tbl_test] (
[seq] [int] PRIMARY KEY NOT NULL,
[domain] [varchar] (70) NOT NULL,
[linkchk] [char] (1) NOT NULL,
[insert_date] [datetime] NOT NULL
)
GO

CREATE TABLE [dbo].[tbl_update] (
[seq] [int] PRIMARY KEY NOT NULL,
[writer] [varchar] (12) NOT NULL,
[title] [varchar] (100) NOT NULL,
[insert_date] [datetime] NOT NULL
)
GO

INSERT INTO tbl_test VALUES ( 1, 'www.webmadang.net', 'Y', getdate());
INSERT INTO tbl_update VALUES( 1, '웹마당넷', '업데이트테스트', getdate());

-- 조인을 이용한 UPDATE 예

UPDATE tbl_update
SET tbl_update.writer = '운영자'
FROM tbl_test
WHERE tbl_test.seq = tbl_update.seq AND tbl_test.linkchk = 'Y'

-- 조인을 이용한 DELETE예

DELETE tbl_update
FROM tbl_test
WHERE tbl_test.seq = tbl_update.seq AND tbl_test.linkchk = 'Y'