query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2006 2315 V8 6.0L 364cid GAS FI N Engine VIN = H V8 6.0L 364cid GAS FI N Engine VIN = H 6.0L 6.0L Y 18 CHEVROLET 3718 TRAILBLAZER SS 4069 SS 20061837182315
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 = '20061837182315'