SQL Help [RESOLVED]

I have the following SQL Query:

VB Code:

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?

Just a guess...

VB Code:

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

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

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

VB Code:

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

Cheers guys :thumb:

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

---

Quote:

---

Originally Posted by mik706

Cheers guys :thumb:

---

Which code worked? :D

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.

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