select a.*,b.*,c.* from wine a,test1 b,test2 c where a.name like '%$key%' or (a.test1 = b.id and b.name like '%$key%') or (a.test2 = c.id and c.name like '%$key%')
Date :
23 ก.ค. 2551 15:27:36
By :
Cake
No. 3
Guest
ยังเลยค่า
select a.*,b.*,c.*,d.*,e.* from ((((wijn a inner join test1 b on a.test1=b.id) inner join test2 c on a.test2=c.id) inner join test3 d on a.test3=d.id) inner join test4 e on a.test4=e.id)
where a.name like '%$key%' or b.name like '%$key%' or c.name like '%$key%' or d.name like '%$key%' or e.name like '%$key%';
Load balance : Server 02
