query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2003 2317 V8 6.0L 364cid GAS FI N Engine VIN = N V8 6.0L 364cid GAS FI N Engine VIN = N 6.0L 6.0L Y 16 CADILLAC 1561 ESCALADE EXT 3708 EXT 20031615612317
CACHED false
EXECUTIONTIME 15
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '20031615612317'