You need to use a left join - this forces all records on the left to be included regardless of whether or not there is a corresponding table on the right:
Code:
SELECT * FROM ALLTAGS LEFT JOIN
    Trend_Definitions ON ALLTAGS.Real_Tag_NAME = Trend_Definitions.REAL_TAG_NAME
WHERE Trend_Definitions.REAL_TAG_NAME IS NULL