Hi. Am completely new to Firebird - having been using mySQL til now.

Have a couple of questions:

- is there anywhere I can download documentation on the Firebird
keywords and how to use them eg LEFT, IN etc..

- in mySQL I simulated a crosstab query (eg from MS Access) by
getting the column names, and then creating a query like this to
return the report table in one swoop:

SELECT 'Total', SUM(IF(Kiosks.Name='desktop', Metrics.Copies,
0)) AS 'desktop', SUM(IF(Kiosks.Name='redcoat3', Metrics.Copies, 0))
AS 'redcoat3', SUM(Metrics.Copies) as Total FROM Kiosks INNER JOIN
Metrics ON Kiosks.ID=Metrics.Kiosk_Id WHERE Time IS NOT NULL AND
Copies IS NOT NULL

Is this possible in Firebird, and if not, can anyone suggest another
method?

Many thanks,

David