SQL trouble

[taval]

I currently have an asp script that looks something like :<br><br>------------------------------------------<br><br>StrQuery = &quot;SELECT f.CustId, max(fd.UploadDate)as LastDate from FileDescription f, FileDescription fd, Customer where <br>f.CustId = fd.CustId and f.FileID = fd.FileID <br>Group by f.CustId Order By f.CustId&quot;<br><br>set conntemp=server.createobject(&quot;adodb.connection&quot<br>conntemp.open myDSN<br><br>set allcust=conntemp.execute(StrQuery)<br>allcust.movefirst<br><br>&lt;TR&gt;&lt;TD align= &quot;center&quot; BGCOLOR=&quot;#99FF99&quot;&gt; &lt;%my_link=scriptresponder & &quot;?id=&quot; & allcust(idfield)%&gt;<br>&lt;a HREF=&quot;&lt;%=my_link%&gt;&quot;&gt;Update&lt;/a&gt; &lt;/TD&gt;<br>&lt;TD align= &quot;center&quot; BGCOLOR=&quot;#99FF99&quot;&gt;&lt;% Response.Write allcust(&quot;CustID&quot %&gt;&lt;/TD&gt; <br>&lt;TD BGCOLOR=&quot;#99FF99&quot;&gt;&lt;%my_link=scriptresponder2 & &quot;?id=&quot; & allcust(idfield)%&gt;<br>&lt;a HREF=&quot;&lt;%=my_link%&gt;&quot;&gt;&lt;%Response.Write allcust(&quot;CustName&quot %&gt;&lt;/a&gt;&lt;/TD&gt; <br>&lt;TD BGCOLOR=&quot;#99FF99&quot;&gt;&lt;% Response.Write allcust(&quot;UploadDate&quot %&gt;&lt;/TD&gt;<br>&lt;TD BGCOLOR=&quot;#99FF99&quot;&gt;&lt;% Response.Write allcust(&quot;Fax&quot %&gt;&lt;/TD&gt;<br>&lt;TD BGCOLOR=&quot;#99FF99&quot;&gt;&lt;% Response.Write allcust(&quot;email&quot %&gt;&lt;/TD&gt; <br><br>------------------------------------------<br><br>The problem is I want to be able to call allcust(&quot;CustName&quot from the Customer table and allcust(&quot;UploadDate&quot from the FileDescription table.<br>My Sql statement does not allow me to get this information when I cal it, How can I get all these details?