Hello,

I would need help in building a query, I think it is really easy for someone who know SQL very well. The aim is the following:
I would like to show how many times a document have been downloaded, and when it was clicked for the last time. The query must return the result in a "table format" (I would like at the end to have a result which is displayed in a nice table or at least an understandable table/list).

Here are the explanation to do it:
- in the table DOCUMENTS, I have the fileds "URL" and "Title". Each "URL" is unique and correspond to a "Title".
- in the table URLTracking, I have the field "URL", "Clicks" and "LastClick".
I need to display the TITLE, clicks and LastClick (probably a join between the two tables, but how ?.... And in addition, the result must be displayed in a table or a list, how ?)

Thanks a lot,
DV FX

JUST PERFECT JaverioBCN !!! Thanks a lot !!!!!!!!!!

DV