query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 1995 1698 V6 3.1L 189cid GAS FI N Engine VIN = M V6 3.1L 189cid GAS FI N Engine VIN = M 3.1L 3.1L Y 61 OLDSMOBILE 1284 CUTLASS SUPREME SL 32376 SUPREME SL 19956112841698
CACHED false
EXECUTIONTIME 1
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '19956112841698'