This is returning all the records in Table1 not only the records of LinkField IN (1,2,3,4)

So I had to change it to

select NameField,COUNT(table2.LinkField) FROM

Table1

LEFT JOIN Table2 ON Table1.LinkField =...