I converted a database from Access to MySQL recently. To make the import process easier (I was already using Navaicat which also made it a lot easier) I did not enforce the relationship integrity. Now, weeks later, I am trying to do that but am running into an issue.
I have tables like so -
JOBS (JobID,Title, StartDate,...)
The problem is that Job ID's, the field connecting these two table, have gotten modified in one place and not the other. So, I'd like to run a couple of queries to A) find jobs that don't have a work order, and B) find work orders that don't have a job. This would be straight forward with sub-selects, but I don't have that with this version of MySQL.