I need some help with a MySQL query. I have 2 databases - one contains employee names and whether they are active or not. The other one contains a list of codes/descriptions.
The table ee contains name, code and active
The table eereminders contains code.
I need a query to display which ee.active = 'Y' and which `name` are contained in the eereminders table and which ones aren't. They are linked via ee.code and eereminders.code
I'm guessing it will have to be 2 queries...