I have 2 tables in same database and each table has 30 columns and i want 8 columns from one and 4 columns from another to do search?

See more:

SQL

I have 2 tables in same database and each table has 30 columns and i want 8 column from one and 4 from another to do search?

product

product_ID          int                not null
Can_proj_code     nchar(10)
Project_name       nvarchar(150)
RU                 nvarchar(50)
BU                  nvarchar(25)
MOA                 nvarchar(50)
Indiaction           nvarchar(50)
Phase                 nvarchar(50)
PGRD_Status            nvarchar(50)

ProjSummPubl_Team

Product_ID          int         not null
Role_Name          nvarchar(50)
Assoc_NameLFM           nvarchar(100)
Assoc_NameLFM_HTML    nvarchar(150)

these are the table and i want to do search from these columns and when somebody put any of the data from these fields it will show in grid view
i am using wcf, stored procedure and silverlight4 VS 2010

i want stored procedure for search that can search with all columns from all columns from both tables. and show in grid view combined all 11 columns
[Edit] shouting is rude[/Edit]