Search code examples
mysqlsqlfirebirdresultset

How to make a multiple select query in Firebird


In MySQL I can perform the query I pastebin here. This query results the following result set:

result set from the pastebin query

How can I do something like it against a Firebird database?


Solution

  • Add from RDB$DATABASE to the end of your query - see here.