[thelist] Genealogy database schema

rudy r937 at interlog.com
Tue Jan 7 09:11:01 CST 2003


> 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




More information about the thelist mailing list