SQL语句问题-如何检索主键不作为外键存在于另一个表中的表的记录

SELECT A.*
FROM TableA AS A
LEFT JOIN TableB AS B ON (A.ID = B.TableAID)
WHERE B.TableAID IS NULL

您可以使用“不存在”

SELECT columnlist
FROM TableA
WHERE NOT EXISTS(
   SELECT * FROM TableB
   WHERE TableB.column = TableA.column)

SELECT A.*
FROM TableA AS A
WHERE NOT EXISTS ( SELECT 1
                   FROM TableB
                   WHERE TableA.ID = B.TableAID
                 )

Select * from TableA 
where 
 TableA.TableAID not in (select TableB.TableAID from TableB)