SELECT * FROM
(
SELECT B.NAME FROM SYSOBJECTS A
LEFT JOIN SYSCOLUMNS B
ON A.ID = B.ID
WHERE A.NAME = '表名1'
) SS
WHERE NAME NOT IN
(
SELECT B.NAME FROM SYSOBJECTS A
LEFT JOIN SYSCOLUMNS B
ON A.ID = B.ID
WHERE A.NAME = '表名2'
)
转载于:https://www.cnblogs.com/mishy/archive/2010/09/08/1821178.html