Hello!
I vaguely remember that someone said somewhere that
EXISTS runs faster than IN:
SELECT * FROM table1 where field1 EXISTS (SELECT
field4 FROM table2)
However, all I got from version 7.1.3 is:
ERROR: parser: parse error at or near "exists"
While below works:
SELECT * FROM table1 where field1 IN (SELECT field4
FROM table2)
Any key points I have missed?
CN
--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com