[Old Pedant]

You know, looking at all those views, I think I see the problem in my original query.

I think it is missing the SELECT * that I have in the allresults VIEW.

So maybe this is all that needs added:

SELECT team.TeamID, team.teamName, allresults.wintotal, allresults.individualWins
FROM team
LEFT JOIN ( 
     SELECT * FROM
     ( SELECT rTeamID, SUM( IF(wld='w', 2, IF(wld='d', 1, 0 ) ) ) AS wintotal
       FROM results
       GROUP BY rTeamID ) AS tr
     INNER JOIN 
     ( SELECT x.iTeamID, COUNT(*) AS individualWins
       FROM (
              SELECT iTeamID FROM individResults WHERE fa='f'
              UNION ALL 
              SELECT iTeamID FROM individResultsDoubles WHERE fa='f'
            ) AS x
       GROUP BY x.iTeamID
     ) AS ir
     ON tr.rTeamID = ir.iTeamID
   ) AS allresults
ON team.teamID = allresults.rTeamID
ORDER BY allresults.wintotal, allresults.individualWins