Hi,

At December 17, 2004, 15:50, Garrett Smith wrote:

> Storage Box wrote:
>> Also, sometimes it's better to query more than once to get
>> values+sub-values than it is to make a single monster of a
>> joined/union query.

> This is the design approach I'm taking (and have taken with other
> dbmses), but lack of temp tables and/or subqueries is making it
> difficult.

Subqueries will be available in FB 2.0. And, the requirement for temp
tables has been talked about lately, but no consensus on how to
implement them has really been reached, because there are a few models
to choose from on how to implement them and the SQL standard does
differ to MS-SQL temp tables.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)