Clever Geek Handbook

Multiple columns in a subquery using Firebird

I am looking for a 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 searched for solutions and I found some for other databases, but not Firebird.

Hello

+3


source to share


2 answers 


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


+4


source


Firebird, unfortunately, does not support multiple columns in a subquery.



0


source






More articles:


All Articles