You don't want the extended syntax here. The extended syntax is telling the system to merge the two tables based on IPNUmber (in Start/End range) and LocID. But there's no LocID on the Session table, so the merge doesn't work, and wasn't what you wanted anyway.
All you want to merge on is the IPNumber vs. the Start and End. That's just a regular syntax. To get the LocId back onto the Session table, you'll need a second join.
LEFT JOIN ([Session]) INTERVALMATCH (IPNumber) LOAD Start ,End RESIDENT [IPLocation] ; LEFT JOIN ([Session]) LOAD * RESIDENT [IPLocation] ;
You don't want the extended syntax here. The extended syntax is telling the system to merge the two tables based on IPNUmber (in Start/End range) and LocID. But there's no LocID on the Session table, so the merge doesn't work, and wasn't what you wanted anyway.
All you want to merge on is the IPNumber vs. the Start and End. That's just a regular syntax. To get the LocId back onto the Session table, you'll need a second join.
LEFT JOIN ([Session]) INTERVALMATCH (IPNumber) LOAD Start ,End RESIDENT [IPLocation] ; LEFT JOIN ([Session]) LOAD * RESIDENT [IPLocation] ;
