Hi what's the equal word for "join on " from sql for access , using in query about joining tables.
thanks

Do you mean union?

If you are not familiar with the SQL syntax used by Access, use the QBE grid to build your queries. Then switch to SQL view to view the generated statement. You can get SQL help from Access by opening help while you are in the Database Container window as opposed to the VBA window. Switch the tab to Table of Contents. Look for SQL and drill down. None of this help is available by searching so this is the only way to get it. But, the SQL summary is short enough for you to read it to see all the language elements.

what is QBE ??
thanks

If you are not familiar with the SQL syntax used by Access, use the QBE grid to build your queries. Then switch to SQL view to view the generated statement. You can get SQL help from Access by opening help while you are in the Database Container window as opposed to the VBA window. Switch the tab to Table of Contents. Look for SQL and drill down. None of this help is available by searching so this is the only way to get it. But, the SQL summary is short enough for you to read it to see all the language elements.

Query By Example. It is the query builder. On the query tab of the database container, select New. Choose the tables or queries you want for your query and close the table/query selector dialog. Draw the appropriate join lines to connect the tables/queries. Select whatever columns you want in the recordset. Using the queries menu, change the query type if you need to. The default is "Select". Add any selection criteria to the criteria cells. Select the sort sequence. Save the query. Run it.