unknown table

		sql = "select ft.tid, ft.rid " & _
		      "from forumthreads ft " & _
		      "where ft.usr = "&request.querystring("id")&" " & _
		      "union all " & _
		      "select fp.tid, fp.rid " & _
		      "from forumposts fp " & _
		      "where fp.usr = "&request.querystring("id")&" " & _
		      "order by ft.pdate desc"

Genererar felmeddelandet

[TCX][MyODBC]Unknown table 'ft' in order clause

Varför?

Borde väl vara "forumthreads as ft" och "forumposts as fp"

lägg till pdate i select-listan

sql = "select ft.tid, ft.rid,ft.pdate " & _
		      "from forumthreads ft " & _
		      "where ft.usr = "&request.querystring("id")&" " & _
		      "union all " & _
		      "select fp.tid, fp.rid, fp.?date " & _
		      "from forumposts fp " & _
		      "where fp.usr = "&request.querystring("id")&" " & _
		      "order by pdate desc"

Fungerar utmärkt. Thnx

		sql = "select ft.tid, ft.rid, ft.pdate " & _
		      "from forumthreads ft " & _
		      "where ft.usr = "&request.querystring("id")&" " & _
		      "union all " & _
		      "select fp.tid, fp.rid, fp.pdate " & _
		      "from forumposts fp " & _
		      "where fp.usr = "&request.querystring("id")&" " & _
		      "order by pdate desc"