I read 'cracked' as 'broke'.
But it'll return more than one record when operator have matching route and empty one in the RF1 table. Also, you don't need LEFT JOIN if you want to ignore operators w/o any records in RF1.
>Why yes. In message #
1149276 I said:
>
>
>Thanks Sergey.
>
>No, that didn't work. I seem to have cracked it with:
>
>...
> LEFT JOIN RF1 ;
> On NET.Operator == RF1.Operator ;
> and ( NET.Route == RF1.ERoute ;
> or EMPTY( RF1.ERoute) ) ;
>...
>>
>That's why I asked if you thought that wasn't robust enough. I certainly haven't yet tried it with every permutation of data.
>
>Also, I just need to let you know that I so appreciate your trouble.
>
--sb--