The following query doesn’t work, because Firebird (2.1) won’t recognize the subquery’s column. How can I rewrite it to work? Answer Use a subquery: I would also recommend using COALESCE() in the ORDER BY:
Tag: firebird2.1
Copying tables from one database to another, in Firebird 2.1
I need to copy tables from one database to another in Firebird 2.1, but in some way which is pretty quick and you can run this on console. I used FBcopy but get the answer from boss that it is too slow. This must be done in more than one transaction because tables are quite big. Any ideas how I