SQL query - excluding specified records

[mattygriff]

I am in the process of writing a team selection system for a local sports team and need help with a SQL query. In my database I have a table of fixtures and a table of results with the FixtureID field being common to both. I want to offer the adminuser the option of entering results for any fixtures which have already taken place but have not yet had their result entered. What I need is to retrieve all records from the FIXTURES table with a fixture date equalling or prior to the current date but only if the FixtureID does NOT appear in the RESULTS table. I think I need to use a SQL statement something like NOT IN but I have no idea how to formulate the SQL query.

Can anyone help ????

 

[Philly44]

I think this might at least get you going in the right direction

SELECT *
FROM RESULTS INNER JOIN FIXTURES ON RESULTS.FixtureID =
FIXTURES.FixtureID
WHERE FixtureDate <=Date();