Using AND instead of WHERE in SQL

[neileg]

In this thread,
http://www.access-programmers.co.uk/forums/showthread.php?t=97501
Bhanu has used AND in his SQL when I would have used WHERE. Does this matter?

I'm aware that WHERE is preferred over HAVING, is there a similar issue with AND?

You know I'm not formally trained so please help me advance my knowledge!

 

[ScottGem]

I would have used a Where clause

 

[neileg]

Thanks, Scott, Pat. You have shone a light into my vast cave of ignorance.