Re: query problem

On Tuesday 22 January 2002 13:18, Sommai Fongnamthip wrote: > Hi, > I have problem with these mysql's query: > > select * from holder, management where holder.id=management.id or > (holder.name=management.name and holder.surname=management.surname) order > by holder.no > > It take a long time (more than 1 minute) with thousand record. I have > index within 2 table (name+surname, id). It did not have problem if I > check only id or name+surname. This is a mysql question. Perhaps you should ask on the mysql list. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* One expresses well the love he does not feel. -- J.A. Karr */