Re: A Kind of Reverse Join

[Barry Galbraith]

What you are looking for is called an Exclusion Join.
If you show us your CREATE TABLE statements, and some INSERTs to populate them, we might be able to show you how to write what you want.

So, from a mysql commnad prompt

mysql>SHOW CREATE TABLE Members \G


mysql>SHOW CREATE TABLE Events \G

mysql>SHOW CREATE TABLE mem_event \G

and some Inserts, and we'll be good to go.

BTW.
When you copy/paste the SHOW CREATE TABLE prints, put them between [ code ] and [ /code ] tags, without the spaces I've shown, and it will preserve the formatting and make it easier to read.

Good luck,
Barry.