posted 5 years ago
I really appreciate all the help you are providing. On another site I am getting sledged. Tim H you are totaly correct that this is very complexed so I have simplified it below. Knute I have tried your change with no difference. Tim C I am afraid the MySQL does not support "EXCEPT". Simplified:
This works:
This does not work:
Initially I only had the third "SELECT". I then added the second "SELECT" to check for "NULL" being returned by the third "SELECT". However, that did not correct the issue.
So "SELECT":
One returns the required values (all members not attached to an Account - not in the third "SELECT")
Two checks for "NULL" (i.e., no members currently attached to an Account - so return all members)
Three returns all members currently attached to the Account and therefore should be excluded from the list returned by the first "SELECT")
I am not a programmer, learning as I go and doing this for my Scouts.
Kind regards,
Glyn