Difference between revisions of "Technical Notes"
From Kbwiki
Aubrey Moore (Talk | contribs) (New page: *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) |
(No difference)
|
Revision as of 12:21, 16 January 2008
- 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