Re: [Firebird-test] can we use queries instead of tables

[Martijn T. <m.t...@up...>]

Hi,

This actually is a topic for "firebird-support", but here you go ...

> hi,
> when i write query instead of tables it doesnt work error -104
> like
> select *from (select name,surname from names) N
> or
> select *from from names n
> left join (select *from adres) a on a.ind=n.ind

You can do this in Firebird 2 and up.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com