Your query looks good at first sight.
Have you tried SQL query builder that comes in VS6 or Access to build your query?
Which database engine do you use?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com