query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2007 2077 V8 4.6L 281cid GAS FI N Engine VIN = A V8 4.6L 281cid GAS FI N Engine VIN = A 4.6L 4.6L Y 16 CADILLAC 3957 XLR 3516 XLR 20071639572077
CACHED false
EXECUTIONTIME 24
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '20071639572077'