>Hi All,
>
>I'm writing a query witn an output to a table that already exists. Strange thing is that the order of the fields is not equal to the order as it is written in the query. It place the fields in alphabetic order in stead of how it is written.
>
>For example:
>
>Select aveld, cveld, bveld from klm into table outputklm
>
>
>I get the following order in the output table aveld, bveld, cveld. How could I solve this?
>
>Thanks beforehand
You shouldn't rely in the order of fields in your code.
However if you really need it, are you sure you're looking at the correct table?
PS: You're saying to a table that already exists but creating a new one with select.
Cetin