SQL Help [RESOLVED]

[mik706]

I have the following SQL Query:

SELECT * FROM ALLTAGS INNER JOIN
Trend_Definitions ON ALLTAGS.Real_Tag_NAME = Trend_Definitions.REAL_TAG_NAME

This passes back all the records in ALLTAGS that exsist in Trend_Definitions.

How can i change this to return all the recordes from ALLTAGS that DO NOT exist in Trend Definitions?

[dee-u]

Just a guess...

SELECT * FROM ALLTAGS NOT IN 
(SELECT * FROM ALLTAGS INNER JOIN Trend_Definitions ON
 ALLTAGS.Real_Tag_NAME = Trend_Definitions.REAL_TAG_NAME)

[maxpert]

SELECT * FROM ALLTAGS
WHERE ALLTAGS.Real_Tag_Name NOT IN
(SELECT Trend_Definations.Real_Tag_NAME FROM Trend_Definitions)

[dglienna]

I think this is right. Kind of late, so I'm not going to test it.

SELECT * FROM ALLTAGS LEFT JOIN
Trend_Definitions ON ALLTAGS.Real_Tag_NAME <> Trend_Definitions.REAL_TAG_NAME

[mik706]

Cheers guys

[visualAd]

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:

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

[dee-u]

Cheers guys

Which code worked?

[mik706]

Maxperts and visualAds both worked.
I got "Incorrect syntax near the keywork 'NOT'" when i tried yours and
dgliennas just returns the first record from ALLTAGS against all the records in Trend_Definitions.

[dglienna]

Glad that one of them worked for you. We all learned something.
I learned to try to test before posting