hvorfor får jeg denne fejl?

Her er min kode:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={MySQL};SERVER=&_
"DATABASE=;"
Conn.Open DSN
%>




<%
SQL = "SELECT  t1.varenummer, t1.DescShort, t1.pris, t1.levnavn  "
SQL = SQL & "FROM (SELECT levnavn, pris, varenummer, DescShort FROM tabel1 "
SQL = SQL & "UNION ALL SELECT levnavn, pris, varenummer, DescShort FROM tabel2 "
SQL = SQL & "UNION ALL SELECT levnavn, pris, varenummer, DescShort FROM tabel3) "
SQL = SQL & "as t1, "
SQL = SQL & "(SELECT min(pris) as mpris, varenummer "
SQL = SQL & "FROM (SELECT pris, varenummer FROM tabel1 "
SQL = SQL & "UNION ALL SELECT pris, varenummer FROM tabel2 "
SQL = SQL & "UNION ALL SELECT pris, varenummer FROM tabel3 "
SQL = SQL & ") GROUP BY varenummer) as t2 "
SQL = SQL & "WHERE t1.pris = t2.mpris AND t1.varenummer = t2.varenummer ORDER BY t1.varenummer;"

Set rs = Conn.Execute(SQL)

Response.Write "<table>"
if not rs.EOF then
  Response.Write "<tr>"
  for each f in rs.Fields
    Response.Write "<td>" & f.name & "</td>"
  next
  Response.Write "</tr>"
end if
Response.Write "<tr><td>"
Response.Write rs.GetString (, -1, "</tr><td>", "</td></tr><tr><td>", NBSPACE) 
response.write "</table>"
%>

Her er min fejl:

[TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT levnavn, pris, varenummer, DescShort FROM tabel1 UNION A


og jeg kører Mysql verion : MySQL 4.0.17.