Обсуждение: select question

Hi,

is there anybody who can say my why following select-statement make
no results:

select main.name, main.sortname, main.stadt, main.id, statistik.hits from
main, statistik where main.id = statistik.mu_id order by statistik.hits
DESC, main.sortname

I do not get any error, but no result too. I have tuples in statistik and
main where the main.id = statistik.mu_id

Any hints?

Thanks

Christian

--
 Christian Guenther         http://laokoon.in-berlin.de/Kuenstler/
 Fax: +49 030 4464152       http://laokoon.in-berlin.de/Museum/
 Tel: +49 030 4442931       E-mail: guenther@laokoon.in-berlin.de