Re-check my reply as well then. I found yesterday this problem too, but was not sure this is the one.
>Sheesh, I threw the order by on last minute. Amazing. I sure didn't see it last night (guess I was too tired :o) Thanks so much Del!
>
>
>
>>>IF SQLEXEC(lnConnection,m.lcSQL) > 0
>>> TEXT TO lcSQL2 NOSHOW PRETEXT 15 TEXTMERGE
>>> SELECT qry2.table2id, vh.* from table3 as vh
>>> INNER JOIN (<
>) qry2
>>> ON vh.vehi_id = qry2.vehi_id ORDER BY vehi_id
>>> ENDTEXT
>>
>>You need an alias in the ORDER BY clause. I'm surprised this works in 2005.
If it's not broken, fix it until it is.
My Blog