Topic: Show all but these records...

[xoligy]

Ok i have tried a few variations of this code and all have come out the same it will show me the records of the selected numbers but i dont want that i want the ones not equal to them lol

So i want it to display all the records in misisons where miss_id (in comp) is not equal to id (in missions) thought it be simple but i just get a blank table lol

here is the funky code

Code: [Select]

"select missions.id, missions.mission,missions.location, missions.level, missions.loot, missions.energy, missions.energy1, missions.bronze, missions.silver, missions.gold, missions.platinum, comp.miss_id, comp.user_id, comp.completed from missions, comp where comp.user_id=1 and comp.miss_id=missions.id"


[xoligy]

Take it what i want isn't possible then :/

[ajlisowski]

SELECT id, mission, level, location, loot FROM missions WHERE id NOT IN (SELECT miss_id FROM comp)

[xoligy]

Thanks for that ajlisowski! Never seen that done in a tut