젠장 여적 몰랐네.
-- 하위쿼리 사용
DELETE FROM titleAuthor
WHERE title_id IN
( SELECT title_id
FROM titles
WHERE title LIKE '%computer%')
- SQL92
DELETE FROM titleAuthor
FROM titleAuthor AS A
INNER JOIN
titles AS B
ON A.title_id = B.title_id
WHERE A.title LIKE '%computer%'
-- Transact-SQL
DELETE FROM titleAuthor
FROM titleAuthor AS A, titles AS B
WHERE A.title_id = B.title_id
AND B.title LIKE '%computer%'
