SQL Query – SELECT with AND clause question…

Hi All,
I have the below SQL SELECT Script….

Code:
SELECT c.Title, c.Forenames, […]

Original post by Graham_K