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.trap_id=trap_routes.trap_id