Hjælp fra Access til MySQL

I Access kunne jeg gøre sådan, nogen der kan hjælpe mig med hvordan det er i MySQL ?

SQLstmt = "SELECT "
SQLstmt = SQLstmt & "(Select AcceptVIPRules FROM UserInfo WHERE ( ID = " & User & " )) AS UserStat, "
SQLstmt = SQLstmt & "(Select count(*) FROM Topics WHERE ( User = " & ID & " )) AS TotalVarer, "
SQLstmt = SQLstmt & " * FROM UserInfo WHERE ID = " & ID & " ; "
Set RS = Conn.Execute(SQLstmt)