I am having problems trying to figure out how to filter results from one table based on another table. In the project, many sites will be using the same database, but the results will be filterd for each site. I'm using asp/sql and have two tables in a database that are set similiar to this:
I want to display all the sites from the LinkSite table, except the ones that are set to be filtered in the second table by the field "FilterSiteId".
Is there a type of join I could use to achieve this?