Come faccio a trasformare il codice SQL postato in modo da poter interrogare una tabella di access?
codice:
Set Command = Server.CreateObject("ADODB.Command")
With Command
Set Command.ActiveConnection = Conn
Command.CommandText = "SELECT Tabella.codice, Tabella.cognome, Tabella.nome, Tabella.id, Tabella2.codice, "
Command.CommandText = Command.CommandText & " (COUNT(CASE WHEN Tabella2.cash=0 THEN 1 END )) AS campo1, "
Command.CommandText = Command.CommandText & " (COUNT(CASE WHEN Tabella2.eseguito=1 AND cash1=0 THEN 1 END)) AS campo2, " 
Command.CommandText = Command.CommandText & " (SUM(Tabella.importo)) AS totimporto "
Command.CommandText = Command.CommandText & " FROM Tabella "
Command.CommandText = Command.CommandText & " LEFT OUTER JOIN Tabella2 "
Command.CommandText = Command.CommandText & " ON Tabella.codice=Tabella2.codice "
Command.CommandText = Command.CommandText & " WHERE Tabella.codice =" & varcod
Thanks!