From: bkausbk@web.de   
      
   Hello again,   
      
   unfortunately it doesn't work as expected. SQL CE says, it can't find   
   column C.Metric   
      
    > JOIN (SELECT RouterId, DeviceId, MIN(ABS(C.Metric - Metric)) AS   
   min_metric   
      
   So I think it's time to find another solution. May be I could call that   
   query for each DeviceId, but SQL CE on my smart device is really slow as   
   it is.   
      
   Benjamin Kalytta   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)