query
RESULTSET
query
  ACTIVE AUTOYEAR ENGINEID ENGINENAME ENGINENAME ENGSHORT ENGSHORT GMFORD MAKEID MAKENAME MODID MODNAME RECNO TRIMLEVEL VID
1 N 1991 3 Any Any [empty string] [empty string] Y 18 CHEVROLET 2223 KODIAK C7500 4X2 C 2WD 6098 C7500 4X2 C 2WD 19911822233
CACHED false
EXECUTIONTIME 14
SQL select e.enginename, e.engshort, ymm.* from yearmakemod ymm inner join enginecode e on ymm.engineid = e.engineid where vid = '19911822233'