query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 [empty string] 2002 1462 L6 7.2L D EFI TURBO L6 7.2L D EFI TURBO 7.2L 7.2L Y 31 GMC 3629 TOPKICK C6500 4X2 C 2WD 21007 C6500 4X2 C 2WD 20023136291462
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 = '20023136291462'