don't want another db table, plz help?

[taval]

currently I have these two SQL queries:<br><br>StrQuery = &quot;SELECT f.CustId, max(fd.UploadDate)as LastDate into tempererer from FileDescription f, FileDescription fd, Customer where f.CustId = fd.CustId and f.FileID = fd.FileID Group by f.CustId&nbsp;&nbsp;Order By f.CustId&quot;<br><br>srt = &quot;Select tempererer.CustId,Customer.CustName,tempererer.LastDate from Customer, tempererer where Customer.CustID = Tempererer.CustId&quot;<br><br>As can be seen the second query uses a table created by the first to get the results needed, how would I be able to produce one query that gives the same effect but doesn't create a new table since this creates problems. Grateful for any help. Thanks.

 

[NickBulka]

I think you might want to research hierachical recordsets.