Filtering Results

[sladewilson]

I can't seem to figure out how to display all items in one table that are NOT in the other. Here's what I have for a database.

First Table called "Members" contains stuff like MemberID, FirstName, LastName, etc...

Second Table called "Colors" contains stuff like ColorID, ColorName, MfgNumber, etc...

Third Table called "Selections" contains only two columns. One is MemberID the other is ColorID.

Members are presented an HTML form with all the colors in the "Colors" table. They can select a checkbox for any or all colors they want. When they hit submit the results are stored in the "Selections" table by MemberID and ColorID.

My problem is I DON'T want them to be able to see a color(s) they have previously selected the next time they view the HTML form of all available colors.

How can I accompish this?

 

[Sheco]

Isn't this not so much an ASP question as it is a SQL question?

 

[sladewilson]

Thanks for the answer :-/

 

[TheCandyman]

Yes SQL form would be better, but you need to use or read on how to use the left join.

SELECT * FROM ADTable LEFT JOIN Web_code ON [ADTable].[PIC] = [Web_code].[DESCR] WHERE ([Web_code].[DESCR] Is Null);


This may be good reading

http://www.databasejournal.com/sqletc/article.php/26861_1402351_3