Re: SQL query help

[Quoted] Brian, I got this error

12:50:49 PM ORA-00904: "CLIENT_STRUCTURE_RECORD_ID": invalid identifier

because CLIENT_STRUCTURE_RECORD_ID is not part of SQL, we cannot use in outer order by clause.

any ideas??

Thanks

Brian Peasland wrote:
> Put your ORDER BY clause outside of the sub-select:
>
> SELECT distinct * from (SELECT
> Client_Structure_Version.CLIENT_STRUCTURE_ID, FIELD_NAME,
> FIELD_TYPE, FIELD_WIDTH, FIELD_ORDER
> FROM Client_Structure_Version)
> ORDER BY client_structure_record_id,FIELD_ORDER;
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Wed Aug 23 2006 - 18:54:03 CEST