Hi,

> and if you use this
>
> SELECT * FROM T2 WHERE (FIELD1,FIELD2,FIELD3) IN (SELECT

FIELD1,FIELD2,FIELD3 FROM T1);

>

A tuple comparison like this is not supported in Firebird.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com