×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Pulling damage counts by ramp and date range

0
0
 
0
Language: SQL
Posted by: Marcus Hamilton
Added: Jun 20, 2017 3:32 PM
Views: 2392
Tags: no tags
  1. SELECT veh.VEH_VIN, insp.INS_DAMAGE_COUNT, insp.INS_DATE dmg.
  2. FROM DAT_INSPECTION insp, DAT_VEHICLE veh, DAT_DAMAGES dmg
  3. WHERE
  4. TCU_ID=188
  5. AND insp.SIT_ID = '42R'
  6. AND insp.INS_DAMAGE_COUNT > 0
  7. AND insp.ins_date >= to_date('15-jun-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')
  8. AND insp.ins_date <= to_date('17-jun-2017 23:59:59','DD-MON-YYYY HH24:MI:SS')
  9. AND insp.VEH_ID = veh.VEH_ID

Write a comment

To post comments, please log in or register.