Received: from tron.marelli.it (tron.marelli.it [139.128.18.2]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA60512 for ; Fri, 18 Feb 2000 12:52:24 -0500 (EST) (envelope-from Rodrigo.Rezende@hortolandia.marelli.it) Received: from boeing.hortolandia.marelli.it (boeing.hortolandia.marelli.it [139.128.108.251]) by tron.marelli.it (8.9.3/8.9.3) with ESMTP id SAA21752 for ; Fri, 18 Feb 2000 18:48:09 +0100 (MET) Received: from hortolandia.marelli.it (intranet.hortolandia.marelli.it [139.128.108.136]) by boeing.hortolandia.marelli.it (8.8.6 (PHNE_14041)/8.8.6) with ESMTP id PAA25362 for ; Fri, 18 Feb 2000 15:50:43 -0300 (SAT) Message-ID: <38AD95C6.C8020910@hortolandia.marelli.it> Date: Fri, 18 Feb 2000 15:56:06 -0300 From: Rodrigo Rezende X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Select & Tables X Select & Views Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all!, Using the following query : select * from taba, tabb; The result will be taba's number of rows * tabb's number of rows result = rows(taba) * rows(tabb) 1.ex.: taba : 1 2 3 tabb a b select * from taba, tabb; : 1 | a 2 | a 3 | a 1 | b 2 | b 3 | b This occurred because I didn't use the clause Join and Where... But, using a View instead of tabb(table), the number of rows was the same of the view 2. ex.: taba : 1 2 3 viewb a b select * from taba, viewb; : 1 | a 1 | b Why this occurred? I would like this second example returned the same as the first Thanks a lot, Rodrigo C. Rezende