Hello all.
I am having a lot of trouble coming up with the query I need to do the following:
I have 3 tables involved in the query:
Projects, Contracts, ProjectContract
The ProjectContract table relates the other two tables by a project_id and a contract_id. My goal is to find the records whose link is broken. A project and a contract are considered related if they have the same 'title' value. So my logic says to find those records that have the same 'title', but whose 'project_id' and 'contract_id' fields are not related in ProjectContract.
Any suggestions?
Thanks for your time.
I am having a lot of trouble coming up with the query I need to do the following:
I have 3 tables involved in the query:
Projects, Contracts, ProjectContract
The ProjectContract table relates the other two tables by a project_id and a contract_id. My goal is to find the records whose link is broken. A project and a contract are considered related if they have the same 'title' value. So my logic says to find those records that have the same 'title', but whose 'project_id' and 'contract_id' fields are not related in ProjectContract.
Any suggestions?
Thanks for your time.