I have a working Access 2000 query that generated the following SQL statement:
SELECT zones.name, wo.id, clients.company, wo.closed, users.last, wo.notes, wo.quick, wo.created, [LSSMA-WO-Sub].start, [LSSMA-WO-Sub].stop, [LSSMA-WO-Sub].tech, [LSSMA-WO-Sub].details
FROM (zones INNER JOIN (clients...