select from select (IB)

[SilverAG]

Hi!
How can I make select from select in interbase?
OR
join select query

for example:

select * from a
join (select * from b)
on ...

Thanks!

Armands.

 

[Otto]

This syntax is very strange for me, but maybe useful .
Why do you need it?

Using IB, you have to put the second select into a view or a stored procedure.

Otto

 

[MartijnTonies]

You can't. This isn't supported in IB - however, much other stuff is. Tell us what you want, perhaps we can help you in another way.


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com