> > This is an example taken from one of our MSSQL databases:
> >
> > CREATE VIEW dbo.vProjectQAAction AS
> > SELECT QATestAction.TestDate, QATestAction.Outcome,
> > Project.ProjectID, Project.ProjectName, Project.ShortName,
> > QATestAction.Tester
> > FROM QATestAction
> > INNER JOIN ModuleAction ON QATestAction.ActionID=ModuleAction.ActionID
> > INNER JOIN Project ON QATestAction.ProjectID=Project.ProjectID
>
> Ehm, this should work fine with Firebird.
>
> With regards,
>
> Martijn Tonies

Yikes - that was quick :)

Ehm, swiftly moving on...