Filtering the results of one query for another

[Guest_imported]

I have two tables one called suspend with a field called ChanName and another table called chanlist also with a field called ChanName. Basically I would like a query that will select everything from chanlist EXCEPT where a ChanName in suspend matches the ChanName suspend table.
Can anyone help me because this is making my head hurt

 

[snowboardr]

Why don't you just make a column in chanlist, that is called suspend.. and if the person or whatever is suspend, then insert a "y" into it..


Then you would have an easy query instead of doing a crazy one...

Select * from chanlist where suspend <> &quot;y&quot;

www.vzio.com
ASP WEB DEVELOPMENT

 

[TheSaviour]

That would be inefficient and leave a lot of wasted space and unnecessary nulls.
Besides I need to store other information in the suspends table like who suspended it and why.

 

[OldProgrammer]

if I've got the requirement correct

What about:

SELECT * FROM chanlist
WHERE channame NOT IN
(SELECT channame FROM suspend) ?