use auto complete Extender with this type of query!..
Example
select category from tbl_category where " +
"category like @SearchText + '%' union select cmpny_name from tbl_companydetails where cmpny_name like @SearchText + '%'
try like this with your table structure!...