Thanks Sean,
Your suggested query works correctly on Fb 1.5 and FB 2.1. I'll modify the
queries in our application code and see if our tests pass.
I don't know enough about sql to be able to guess why the original query
doesn't work. In assembling the test scripts, it actually worked ok before
I
The following script works on FB1.5 but not FB 2.0+
I'm not sure if I can attach a file so I'll also embed the sql script in
the email. I run the script using isql. The script creates the database so
the ods should be correct for each ver of FB.
cheers
Paul
/**Script Start ***/
/
Hi,
I'm porting an application from FB1.5 to 2.x and a query that worked on 1.5
doesn't work on 2.0 or 2.1 (I haven't tried 2.5)
The query is:
SELECT u.Id, u.Name, u.Email FROM Punter u
WHERE u.ALIVE = 1
/* and they haven't blacklisted this issue */
AND u.Id not IN (SELECT bl.UserId FROM Iss