Eshika (10/9/2013)
Bellow is the code:
I think maybe not. The "C" derived table doesn't have the "townlist" column that have you in the update list. Also, why are you calculating a "ClliList" when it's not being used anywhere and that same thing goes for the two temp tables you create... they're also not being used anywhere.
Please help us help you. Read the article that you've been directed to.
--Jeff Moden
Change is inevitable... Change for the better is not.