Hei!

I have to tables; tblProdukt and tblBestilling. TblProdukt has cell
p1, p2 and p3. TblBestilling has cell b1, b2, b3 and ProduktName.

How can I have two tables held open at the same time and what would the query/VB-script be?

SELECT * from tblProdukt AND tblBestilling WHERE tblBestilling.ProduktName = session("ProduktName"),

And here comes (in words) my query;

AND
tblProdukt.p1 = tblBestilling.b1
AND
is tblProdukt.p2 <> tblBestilling.b2
AND
is tblProdukt.p3 = tblBestilling.b3

The result of the query is then to be %= on a page when some update-button is moused on!

Do While ObjRs. not EOF
<%=ProduktName%>
Loop

Thank you for reading and any answer you maight have.

Med vennlig hilsen

grstad

__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!

SELECT * FROM tblProdukt AS P, tblBestilling AS T WHERE T.ProduktName = session("ProduktName") AND P.p1 = T.b1
AND P.p2 <> T.b2 AND P.p3 = T.b3

... this gives the error; expeted end


Set objCommand = Server.createObject ("ADODB.Command")

objCommand.ActiveConnection = kobling

objCommand.CommandText = "SELECT * FrOM Produkt AS P, Bestilling AS B " & "WHERE (P.ProduktName <> session("navn") & AND P.ProduktSnekker = B.PartnerSnekker & AND P.ProduktKjonn = B.PartnerKjonn & AND P.ProduktMale = B.PartnerMale)"

objCommand.CommandType = adCmdText

set ObjRs1 = objCommand.Execute
Set objCommand = Nothing

While not ObjRs1.EOF
    response.Write ObjRs1("ProduktNavn") & "<br>"
    ObjRs1.MoveNext
Wend
ObjRs1.Close
Set ObjRs1 = Nothing


... I do need help with the ' and the & and the "'s

Med vennlig hilsen
grstad