Nando Dessena wrote:

> J> Well, as you say, that doesn't (currently) work, and besides, it's a
> J> significantly more obscure syntax. Also, what do you mean by "select 4
> J> bob, 6 larry"? Did you forget the "as" or is this a new syntax I'm not
> J> aware of?
>
> - surround the inner select with () and it will work (in Fb2).
>

Ok.

> - the AS keyword has never been required for column names.
>

Oh really, I didn't realize that. However, I also notice that the alias
is being referenced in the on clause, which was not possible up till
now. Is this a new feature of FB 2?

> - I also think that a tuple, or row, datatype would be useful. It has
> been discussed several times in the past here.
>

Glad to hear you say so. :)

--
Best regards,
Jonathan Neve
_______________
CopyTiger - advanced database replicator for Interbase/Firebird!
Web : http://www.microtec.fr/copycat/ct
_______________________________________
CopyCat - database replication components for Delphi/C++Builder!
Web : http://www.microtec.fr/copycat/cc