Re: SQL query help

[Quoted] 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