you have to order by a column name.
Actually you don't I've just done some tests and the above query works exactly as I want. I suppose I was just posting here as a sanity check. Now I can give my results weightings :D Yipeee..
Actually you don't I've just done some tests and the above query works exactly as I want. I suppose I was just posting here as a sanity check. Now I can give my results weightings :D Yipeee..