I have two tables, a Project and an Action:
Project has the following fields:
Action has the following fields:
action_name project status
There is a one-to-many relationship between Action and Project.
I need a query that returns all the Projects that ONLY have actions with statuses greater than 1 OR Projects with no actions at all.
I've never written a query that is dependent on a relationship. How might this be constructed?