sSQL INNER JOIN che non va...

[wegawhite]

Perchè questa query non estrae nulla dal dbase?:

REG = Request.querystring("REG") 
PROV = Request.querystring("PROV") 
COM = Request.querystring("COM") 
COND = Request.querystring("COND")

............

elseif (REG <> 0 AND ucase(trim(COND)) = "TUTTE") then
sSQL = "SELECT DISTINCT TB1.id_REG, TB2.* FROM TB2 INNER JOIN TB1 ON TB2.id_REG = TB1.id_REG WHERE TB2.COND = '"&COND&"' AND TB2.id_REG = "&RE&" "
Set RS = ConnDown.Execute(sSQL)