> Hello,
>
> I want to insert some ordered records into an empty table, but
> Firebird seems not to support "ORDER BY" in an insert-clause (why
> not???).
>
> Is there any workaround?
>
> Example:
>
> INSERT INTO MANUFACTURER (manufacturer.name, manufacturer.id)
> SELECT iSOURCE.MANUFACTURER_NAME, iSOURCE.MANUFACTURER_ID
> FROM iSOURCE
> GROUP BY iSOURCE.MANUFACTURER_NAME, iSOURCE.MANUFACTURER_ID
> ORDER BY iSOURCE.MANUFACTURER_NAME

If you've GROUPed by then you have already ORDERed by - try it without the
ORDER BY clause
Alan