
March 25th, 2000, 01:53 PM
|
|
Apprentice Deity
|
|
Join Date: Jul 1999
Location: Niagara Falls (On the wrong side of the gorge)
Posts: 3,237

Time spent in forums: 4 m 8 sec
Reputation Power: 17
|
|
|
select table1.id,table1.desc as desc1,table2.desc as desc2 from table1,table2 where table1.id=table2.id and desc2 like "%keyword%";
Just a quick note, desc is not allowed as a column name in mysql.
|