Hi Bala,

As Dan pointed out to you. A index { Index1} would speedup your query.
Outer join will never work, It is nothing to do with syntax. Infact it
will change the logic of the query.

Try out creating index and let me know. Could you please set SET
STATISTICS IO ON and show me the stats before & after index creation.

Thank you
Raju