SQL Union fra en anden database

det er en MYSql database

Det her virker ikke

Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open db
strSQL = "SELECT * " &_
    "FROM TGP.DBO.paysites " &_
        "WHERE SiteName LIKE '%FilmO%' ORDER BY SiteName asc" &_
        " UNION " &_
        "SELECT * " &_
        "FROM TGPX.DBO.paysites " &_
        "WHERE SiteName LIKE '%Raven%' ORDER BY SiteName asc"
Set rs = Connect.Execute(strSQL)

luk