I have two tables that exist in a MySQL Database, that are connected to my
Access Application over an ODBC connection, which is linked.
I want to be able to join together two tables in a query and edit the results.
FROM Fileroom AS fr
LEFT JOIN fin_prod AS fn
The CIS Account ID is unique in both cases, however;
1 might have more than the other. Is it possible to edit
the results of this query?