If you want to get all techs from
users
table and jobs completed by each of them, try this:
SELECT u.username, u.groupname, COUNT(j.completed)) AS CompletedJobsCount
FROM [users] AS u LEFT JOIN jobdetails AS j ON u.username = j.Techname
WHERE j.completed = '2015-03-29'
GROUP BY u.username, u.groupname