complex sql-command

[jennifer weinberg]

Hi,
since several days I'm trying to find a solution (it's some kind of homework
for my university studies), and I'm starting to get desperate,
because I cannot find a solution.

There are severel tables given, named by calendar weeks:

1_url
1_hits
2_url
2_hits
.
.
52_url
52_hits

The TABLE-STRUCTURE of each table looks like this...

1_url
=> id
=> url

1_hits
=> urlid
=> date
=> hits

How can I get a search result like below, by using a sql command,
...without using a script (..like php)?

---------------12-03-2005--------13-03-2005-------14-03-2005--------- ...
url_1---------------215---------------220---------------218---------------
url_2---------------430---------------400---------------450---------------
url_3---------------320---------------350---------------360---------------
.
.

Thanks a lot for your help,
Jennifer