optimize query

From: Vadim Grepan <kezal_at_mail.ru>
Date: Mon, 27 Sep 1999 15:22:16 +0400
Message-ID: <7snk64$3nj$1@storm.comstar.ru>

Hello All!

  Is there any way to reduce SQL-query like

                ...
                WHERE    x1 IN (a1, a2, ... an)  AND
                                x2 IN (a1, a2, ... an)  AND
                                x3 IN (a1, a2, ... an)

  In other words, can i use some cosntruction with meaning (x1 ... xm) IN (a1 ... an)
  ( where m < n of course :-)

Rgds, Vadim Grepan

---

kezal_at_mail.ru
2:5020/653_at_fidonet.org Received on Mon Sep 27 1999 - 06:22:16 CDT