Thread

select question

Christian Guenther <guenther@laokoon.in-berlin.de> — 1998-07-30T08:11:54Z

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