Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Marcus Hamilton
Added: Nov 1, 2018 1:10 PM
Views: 4
Tags: no tags
  1. SELECT Insp.INS_ID, Veh.VEH_VIN, VP.VINDIVISIONNAME
  2. FROM AVIS_APP.DAT_INSPECTION Insp, AVIS_APP.DAT_VEHICLE Veh, AVIS_APP.VINPATTERN VP
  3. WHERE LOC_ID = 'UR1608'
  4. AND Insp.VEH_ID = Veh.VEH_ID
  5. AND (SUBSTR(Veh.VEH_VIN, 1, 8)||'*'||SUBSTR(Veh.VEH_VIN,10,1)||'*******') = (SUBSTR(VP.VINPATTERN, 1, 8)||'*'||SUBSTR(VP.VINPATTERN,10,1)||'*******');