consulta de 2 tablas

[TERE_20_20]

me podrias dar un ejemplo por favor
esque soy nueva en utilizar asp
y todavia no he manejado todo
:)



sql1="select '"&tabla2&"'.id_downHead, SUM('"&tabla2&"'.boards_door2) AS suben2, SUM('"&tabla2&"'.exits_door2) AS bajan2, SUM('"&tabla2&"'.blocks_door1) AS BLO1, SUM('"&tabla2&"'.blocks_door2) AS BLO2, SUM('"&tabla2&"'.pablos_door1) AS PA, SUM('"&tabla2&"'.pablos_door2) AS PA2,SUM('"&tabla2&"'.boards_door1) AS suben1, SUM('"&tabla2&"'.exits_door1) AS bajan1 from '"&tabla2&"'INNER JOIN'"&tabla1&"'"
sql2="on "&tabla2&"'.id_downHead = " &tabla1&"'.id;'"

sql= sql1 + sql2

Set rscp= Server.CreateObject("ADODB.Recordset")
rscp.Open sql, conn, 3 ,3

id = rscp("id")