Subject RE: [IBO] Parsing error for Fb 2.0 with derived tables?
Author Jason Wharton
Wow, that's a really lovely result.

I'll have a looky look.

When was this type of query acceptable as I don't recall ever using that
kind of a FROM clause before.

Jason Wharton


> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Martijn Tonies
> Sent: Thursday, December 21, 2006 2:47 AM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] Parsing error for Fb 2.0 with derived tables?
>
>
> Arno forwarded me this:
>
> SELECT
> dt.*
> FROM
> (SELECT
> r.RDB$RELATION_NAME,
> rf.RDB$FIELD_NAME
> FROM
> RDB$RELATIONS r
> JOIN RDB$RELATION_FIELDS rf ON (rf.RDB$RELATION_NAME =
> r.RDB$RELATION_NAME)) dt
>
> Error:
> SQL error code = -206 Column unknown
> R.RDB$RELATION_NAME.DB_KEY At line 4,
> column 30.
>
> This is the SQL trace:
>
> SELECT
> dt.*
> , "R.RDB$RELATION_NAME".RDB$DB_KEY
> FROM
> (SELECT
> r.RDB$RELATION_NAME,
> rf.RDB$FIELD_NAME
> FROM
> RDB$RELATIONS r
> JOIN RDB$RELATION_FIELDS rf ON (rf.RDB$RELATION_NAME =
> r.RDB$RELATION_NAME)) dt
>
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL,
> NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com