Link the two queries together: SELECT name,count(*) FROM driver JOIN car on (name = owner) UNION SELECT name,0 FROM driver WHERE name NOT IN (select owner from car) NAMECount(*) Jim Smith2 Bob Smith1 Bob Jones1 David Davis0