Re: SQL query help

Al Reid wrote:
>
> Perhaps if you move the ORDER BY to the outer SELECT it will return
> the records in the order you want.
>
> 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;

Actually, I think it should have been

 SELECT distinct * from (SELECT
   Client_Structure_Version.CLIENT_STRUCTURE_ID, FIELD_NAME,     FIELD_TYPE, FIELD_WIDTH, FIELD_ORDER     FROM Client_Structure_Version)
 ORDER BY FIELD_ORDER;

-- 
Al Reid

"It ain't what you don't know that gets you into trouble. It's what you
know for sure that just ain't so."  --- Mark Twain