Technical Notes

• Query to find unmatched trap_id's:

SELECT
  trap_routes.trap_id, trap.trap_id
FROM 
  trap_routes LEFT JOIN trap ON trap_routes.trap_id = trap.trap_id
WHERE 
  trap.trap_ID IS NULL

• Query to update trap table using values from trap_routes table:

UPDATE 
  trap, trap_routes 
SET 
  trap.trap_route = trap_routes.trap_route,
  trap.trap_route_sequence = trap_routes.trap_route_sequence 
WHERE 
  trap_routes.trap_id = trap.trap_id