Andrew Toth <[EMAIL PROTECTED]> schrieb: > thx, > > it's working! > > And the last question - today: > > how can i change the orter of the fields in a table?
If you have a table with field1, field2, field3, and you want to see this table as field3, field2, field1, simple do 'select field3, field2, field1 from table'. Btw.: TOFU (top posting with fullquote below) are silly. HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match