I am having trouble trying to create the correct SQL Statement to pull the required records from the table in the image below.
There are lots of records in the table, but I want to pull the MainId from the table when a couple of conditions are met.
I need something like:
Select MainID From MainFilters Where (FilterId=4 AND FilterValues='9') AND (FilterId=9 AND FilterValues='43')
but only that doesn't appear to work? is it because both conditions are in the same record?