How can i search data from multiple sql data tables

Question

Hi,i am kavitha ..

i have one gridview to display search records,one text box for search text and one search button

how can i search data from multiple data  tables..

can any one help me please...

Thanks in advance