Hi

I have a question about INTERSECTS clause.

Using Oracle:

SELECT * FROM ATBL
INTERSECTS
SELECT * FROM BTBL

Using IB/FB:
SELECT * FROM ATBL
WHERE EXISTS(
SELECT * FROM BTBL
WHERE ATBL.A=BTBL.A
AND ATBL.B=BTBL.B
.
.
.
);

It is bery long. What is the better way?

best regards

Tsutomu Hayashi in Japan
Mail : hayashi@...
Web : http://www.apex-jp.com/ (Japanese Only)
http://dmj.psnet.ne.jp/ (Delphi Magazine)