SQL redundancies

From: <h0444vcs_at_rz.hu-berlin.de>
Date: Wed, 30 Jun 1999 17:10:07 GMT
Message-ID: <7ldj14$jul$1@nnrp1.deja.com>

Dear Readers,

the following SQL Statment produces redundant information.

1 select a.host, a.session_id, b.session_id 2 from weblog a, weblog b
3 where a.session_id != b.session_id 4* and a.host = b.host

like :

host s_id s_id

   hostx  1     20
   hostx  1     56
   hostx  20     1
   hostx  20    56     ...

How has the query to be altered, in order to skip the redundancies ?

I'm looking forward to your suggestions !

Markus Banach

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 12:10:07 CDT