firebird-test

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

[amt <am...@al...>]

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

thanks... 

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

[Pavel C. <pc...@ib...>]

Hi,

amt wrote:
> 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

1. This should be posted to firebird-support list, this one is dedicated 
to Firebird Quality Assurance.

2. You have used derived tables (select instead table name) that are not 
supported in current stable version 1.5. However, they are implemented 
in Firebird 2.0.

best regards
Pavel Cisar
IBPhoenix

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