I have the following SQL that works fine against MS-SQL Server but I can't for the life of me translate it to work on Pervasive.
SELECT
F10."id",
F10."type" As "Type",
F10."ref" As "Reference",
F12."related",
F12."status",
SWF."id" as SWFTid,
SWF."ref" as "Other Reference"...