Received: from frosch.all.de (frosch.all.de [195.35.6.2]) by hub.org
	(8.8.8/8.7.5) with ESMTP id EAA10246 for <pgsql-sql@postgresql.org>;
	Thu, 30 Jul 1998 04:12:43 -0400 (EDT)
Received: from bolzen.denic.net (root@bolzen.in-berlin.de [194.94.235.1])
	by frosch.all.de (8.9.0/8.9.0) with ESMTP id KAA24045
	for <pgsql-sql@postgresql.org>; Thu, 30 Jul 1998 10:12:41 +0200 (CEST)
Received: by bolzen.denic.net (Smail3.2)
	id <m0z1nmc-0007VoC>; Thu, 30 Jul 1998 10:09:54 +0200 (MET DST)
Received: (from guenther@localhost)
	by laokoon.IN-Berlin.DE (8.8.6/8.8.5) id KAA17102
	for pgsql-sql@postgresql.org; Thu, 30 Jul 1998 10:11:55 +0200
Message-Id: <199807300811.KAA17102@laokoon.IN-Berlin.DE>
Subject: select question
To: pgsql-sql@postgresql.org
Date: Thu, 30 Jul 1998 10:11:54 +0200 (MET DST)
X-Charset: ISO-8859-1 
From: guenther@laokoon.in-berlin.de (Christian Guenther)
X-Mailer: ELM [version 2.4 PL25]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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