Q: Multiple columns in subquery using Firebird I'm searching the way to do this in Firebird
 SELECT  field1, field2, field3
 FROM table1
 WHERE (field1, field2) IN
            (SELECT fieldA, fieldB
             FROM table2
             WHERE fieldA = 'XXXXX')

I have searched a solutions and I found some for others databases but not for Firebird.
Regards

A:  SELECT  field1, field2, field3
 FROM table1
 WHERE exists
 (SELECT * 
  FROM table2
  WHERE fieldA = 'XXXXX' and fieldA=field1 and field2=fieldB)


A: Firebird does not support multiple columns in subquery, unfortunately.
