W wxdqz New Member Aug 20, 2008 #1 table 1 and table 2 have no fields in common,my query is: select * from table1,table2 where table1.col like '$search%' or table2.col like '$search%'; what's the result? who can give me a example about select in mutitable. Thanks a lot.
table 1 and table 2 have no fields in common,my query is: select * from table1,table2 where table1.col like '$search%' or table2.col like '$search%'; what's the result? who can give me a example about select in mutitable. Thanks a lot.
