Q:

MS Access VBA query multiple tables

I have two tables in Access, both have a columns named 'procedure' and 'version'
that contain String values    
Recorded training Table 
procedue____________version
PO-123_______________1
PO-123_______________2
PO-123_______________3
PO-456_______________1
PO-456_______________2    
Procedures Table 
procedue____________version
PO-123_______________4
PO-456_______________3   
Recorded training Table contains all the training entered into the system over time,
while Procedures Table contains the most up to date revision for each procedure.  
I need a way of checking if the 'Recorded training Table' contains a record corresponding to a record in 'Procedures Table' (ie the same procedure and correct version), and if not get the highest version for each procedure.  
Any help would be appreciated!
Cheers 

A:

I'd try something like this:
SELECT B.procedue, B.MaxVersion, C.version AS CurrentVersion
FROM (
    SELECT A.procedure, MAX(A.version) AS MaxVersion
    FROM [Recorded training] AS A
    GROUP BY A.procedure
    ) AS B INNER JOIN Procedures AS C ON B.procedure = C.procedure

This is also calling: joins.

