query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2001 2195 V8 5.3L 323cid GAS FI N Engine VIN = T V8 5.3L 323cid GAS FI N Engine VIN = T 5.3L 5.3L Y 18 CHEVROLET 3476 SUBURBAN 1500 4260 1500 20011834762195
CACHED false
EXECUTIONTIME 45
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '20011834762195'