>I can get rid of the Probe by including INNER LOOP JOIN. This also makes the execution plan much simpler. But, it this LOOP clause SQL Server only? Is this the proper way to do this?

Why do you need a JOIN anyway? Are you selecting columns from that extra table?

BTW, an interesting blog post about LOOP JOIN

http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/use-a-outer-loop-join-for-faster-perform/