I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find...
We have a member table called 'members'
several different position tables, one for each level called position_1, position_2 etc
I was supposed to change the ownership of a couple positions in position_4, basically by changing the mem_id in the position record to the new owners Member ID (position was won in a contest)
Instead, I changed them in position_1.
When I realized what I had done, I also realized that I had no way to go back because there is nothing else that tracks who the original owner of that position was...
That is a mistake I won't make again because I'll write a script to do this from now on as well as track who the original owner was,
BUT, in the meantime I need to find the member Records in 'members' that don't have a matching record in position_1.
Could someone help me with the query to list the mem_id and user from 'members' that doesn't have a matching record in 'position_1' based on matching 'mem_id'?
It would be greatly appreciated, as this is a time sensative issue...