An example of this clause type is "AND THAT Lecturer 1 IS NOT Lecturer 2" as in the which select statement below:

NB You can use 'IS' or 'IS NOT' in this type of clause.

Example of Use