select question

From: guenther(at)laokoon(dot)in-berlin(dot)de (Christian Guenther)
To: pgsql-sql(at)postgresql(dot)org
Subject: select question
Date: 1998-07-30 08:11:54
Message-ID: 199807300811.KAA17102@laokoon.IN-Berlin.DE
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)laokoon(dot)in-berlin(dot)de

Browse pgsql-sql by date

  From Date Subject
Next Message G.Elangovan 1998-07-30 14:09:03 Re: [SQL] Problem in Grant and Revoke Query
Previous Message Marcio Macedo 1998-07-29 15:14:43 Money Type question