may i know what is the purpose of joining table2 there

and

seems you post only part of your query please post entire query to resolve your issue

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]