>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.
Del