Hi Helen, everybody,

I have this query that uses the INTERSECT operator. Any suggestions
for how to revise it to Firebird SQL?

SELECT DISTINCT
table1.clientid AS CLIENTID
FROM
CUSTOMER1 table1 Inner join ALLACCT table2 on table1.clientid
= table2.clientid
WHERE
(table2.accttype = 1.0)
INTERSECT
SELECT DISTINCT
table3.clientid AS clientid LABEL='Client Id'
FROM
TEMP6 AS table3;

Thanks in advance for all the help!

-Bill Oliver
SAS Institute