bruge inner join
jeg har det her stykke kodeGetPackageServices = "SELECT * FROM packageservices WHERE packageid = '" & SessionArr(a) & "'"
set RsPackageServices = Conn.Execute(GetPackageServices)
RemServiceStr = ""
Do While Not RsPackageServices.EOF
If RemServiceStr = "" Then
RemServiceStr = "DELETE FROM userservices WHERE serviceid = '" & RsPackageServices("serviceid") & "'"
Else
RemServiceStr = RemServiceStr & " OR serviceid = '" & RsPackageServices("serviceid") & "'"
End If
RsPackageServices.MoveNext
Loop
RemServiceStr = RemServiceStr & " AND brugerid = '" & BrugerID & "'"
Conn.Execute(RemServiceStr)
og så tænkte jeg på om det ikke kan lade sig gøre at gøre det der i 1 sql query ved hjælp af inner join?
