Thanks for your help.I have made little bit change in your query.

1) I pur "or" as against "and"

2) If my search is with int datatype then your query is perfect...

This query works but My search would be anything.for e.g. my data is white and my search is just wh then "=" is not worked so i think i need...

It make query for each column.I don't want this thing.

Eg. If I want to search computer from selected 9 to 10 tables. It can be anywhere like any columns.How can...

Are you online right now? my hotmail id is hozefaunwala@hotmail.com.If possible I want to do chat with you.Thanks

Thanks.This is my join

select distinct

table1.col1,table1.col2,table1.col3,

table1.col4,

table1.col5,table1.col6,table1.col7,

table1.col8,table1.col8,

table1.col9,table1.col10,table1.col11,table1.col12,

table2.col1,table2.col2,table2.col3,

table2.col4,table2.col5,

table3.col1,

table3.col2,table3.col3,table3.col4,table3.col5,table3.col6,

table4.col1,table4.col2,table4.col3,table4.col4,

table5.col1,table5.col2,table5.col3,

table6.col1,table6.col2,table6.col3,

table6.col4,table6.col5,

table7.col1,table7.col2,

table8.col1,table8.col2,

table9.col1,table1.col2

from

table1

left outer join table8

on table1.col1=table8.col1

left outer join table7

on table1.col1=table7.col1

left outer join table6

on table1.col1=table6.col1

left outer join table5

on table1.col1=table5.col1

left outer join table2

on table1.col1=table2.col1

left outer join table3

on table2.table2SN=table3.table2_ChildSN

left outer...

Thanks for your reply But I have 9 to 10 tables and almost each table has 10 to 12 columns. So just think how much big query it is? and...