EXCEPT, NOT IN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself

EXCEPT, NOT IN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself

EXCEPT, NOT IN, JOIN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself