Hi,
need some help!
sql="SELECT a.username,a.ModuleID," & _
"b.ModuleName FROM table1 a, table2 b"&_
"WHERE a.moduleID = b.moduleID" & _
"ORDER BY a.username"
rsPlantilla.Open sql
I got an error message:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near 'a'.
/plantilla/access/userModule.asp, line 32
Thanks,
jhoann