"select main.marka,main.comment, vers.code,vers.vers,vers.chkk,vers.stt 
from main inner join vers on main.code=vers.codem 
where main.marka='ABVK.5801.284.512-03' 
order by vers.vers desc;", conndb, adOpenDynamic, adLockOptimistic

SELECT main.marka, main.comment, vers.code, vers.vers, vers.chkk, vers.stt
FROM main INNER JOIN vers ON main.code = vers.codem
WHERE (((main.marka)="АБВК.5801.284.512-03"))
ORDER BY vers.vers DESC;

"select main.marka,main.comment, vers.code,vers.vers,vers.chkk,vers.stt 
from main inner join vers on main.code=vers.codem 
where main.marka='АБВК.5801.284.512-03' 
order by vers.vers desc;"