Re: Need help with Access SQL

[Devart Team]

You have some tables in a single SELECT statement, so you should say haw tables are joined.

For example:

SELECT o.id, c.name
FROM client AS c, order AS o
WHERE c.id = o.client_id; -- tables are joined by these columns

See the SQL reference about joining tables.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/