I'm trying to do an INNER JOIN to extract a matching fields from another table if sucha match exists. I'm getting asyntax error with this SQL statement:
INNER JOIN pedigree WHERE horses.HorseID = pedigree.HorseID
SORT BY horses.Horse_name DESC
...telling me my FROM clause has a syntax error.
I'm working in Dreamweaver recordsets, but I believe this is a straight-forward SQL issue.
What am I doing wrong?