SELECT SQL

Hi,

I have a following SQL query.

Select a.id,a.name,a.age,a.class,a.tel from table01 a, table02 b where a.name=USER and (a.id=b.id01 or a.id=b.id02 or a.id=b.id03 or a.id=b.id04 or a.id=b.id05 or. a.id=b.id06)

The above query took long time.

How can I optimize this for better result?

Thanks. Received on Tue Apr 24 2007 - 01:39:51 CDT