Minnu (12/4/2012)
am using below query for searching in table 1, how to include table 2 for searching.
you need to make JOIN with second table with first one.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)