i have several tables(10+) and their structure are slightly different
the common things are they have fields "search_key" and "search_link"
and i need to search all tables in their "search_key" field and get a "search_link" from it.
just make an exmple for 2 tables
table1
id | search_key | search_link
1 | abc | www.abc.com
2 | test | www.test.com
3 | search | www.search.com
table2
id | search_key | search_link
1 | other test | www.othertest.com
if i do somthing
select table1.search_link, table2.search_link from table1, table2
where table1.search_key like '%test%' or table2.search_key like '%test%'
it returns
search_link | search_link
www.abc.com | www.othertest.com
www.test.com | www.othertest.com
www.search.com | www.othertest.com
am i miss something in the sql statement??
