Many thanks to all who replied.

To summarize the responses............

When I have

SELECT fields FROM yyy LEFT JOIN xxx ON condition

and later have a WHERE clause involving a field in yyy
it essentially turns the query into an INNER JOIN

is this right?