Did you change the owner of the firebird database file and it's directory to
the firebird user? Are you running these commands as the firebird user or as
root?
Sent via my BlackBerry from Vodacom - let your email find you!
-Original Message-
From: "lyotchik"
Sender: firebird-support@ya
In your working query you are asking firebird to take the rows from comm that
match the where clause and join that small subset of data with the matching
rows in tran. In the one that never returns you are asking firebird to join
every table in tran with every row in comm and then apply the filt