[eluser]yayot[/eluser]
If your tables are related, you can use a inner join trough a table, and then with and or OR, you can choose what field you want from the tables.
like so:
select table1.field1, table2.field2, table3.field3
from relationshiptable
innjer join
table1
on
table1.id = relactionshiptable.table1_id
innjer join
table2
on
table2.id = relactionshiptable.table2_id
innjer join
table3
on
table3.id = relactionshiptable.table3_id
WHERE
table1.field1 like '%something%'
or
table2.field2 like '%something%'
or
table3.field4 like '%something%'
Or somthing like that.
Hope it helps