query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2002 1777 V6 3.8L 231cid GAS FI N Engine VIN = K V6 3.8L 231cid GAS FI N Engine VIN = K 3.8L 3.8L Y 18 CHEVROLET 2558 MONTE CARLO SS 5190 CARLO SS 20021825581777
CACHED false
EXECUTIONTIME 22
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '20021825581777'