> SELECT DISTINCTROW .... > FROM (((((((((((((TblHorses LEFT JOIN TblHorses ....... distinctrow is access only, and you don't need it anyway as for the joins, access requires parentheses, mysql doesn't, but they might still work, try it without them if you're getting syntax errors otherwise i think your query should be okay rudy