I have a problem how to retrive data from two table in an access database,
Menysite1.asp retrive field &#34;category&#34; from table &#34;categories&#34; and the links to menysite2.asp?category=<% =rs(&#34;category&#34 %> menysite2 collects &#34;manufacture&#34; from table &#34;categories&#34; and links to menysite3.asp?<% =rs(&#34;category&#34 %> AND Manufacture=<% =rs(&#34;manufacture&#34 %> menysite3 collects &#34;modell&#34; from tabel &#34;categories&#34; and links to list.asp?<% =rs(&#34;category&#34 %> AND Manufacture=<% =rs(&#34;manufacture&#34 %> AND Modell=<% =rs(&#34;modell&#34 the page list.asp should retrive data from an table called &#34;products&#34; and the fields &#34;artnr&#34; &#34;item&#34; &#34;color&#34; &#34;price&#34;
I have tried the following code but i dont works, could someone help me correct this i&#39;ll be wery happy. Please mail a.s.a.p :-)
Code/
<%
Modell=Request.Querystring(&#34;Modell&#34
Category=Request.Querystring(&#34;category&#34
Manufacture=Request.Querystring(&#34;manufacture&# 34

Set conn = Server.CreateObject(&#34;ADODB.Connection&#34
conn.Open &#34;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&#34; & server.mappath(&#34;data/*.mdb&#34
SQL = &#34;SELECT p.Id, p.Artno, p.Item, p.Price FROM Products p, Categories c WHERE p.Id = c.Id AND p.Id = &#39;&#34; & Request.QueryString(&#34;Modell&#34 & &#34;&#39; AND c.category = &#39;&#34; & Request.QueryString(&#34;category&#34 & &#34;&#39; AND c.manufacture = &#39;&#34; & Request.QueryString(&#34;manufacture&#34 & &#34;&#39;&#34;
set rs = Server.CreateObject(&#34;ADODB.Recordset&#34
rs.Open SQL, conn, 3, 3
%>