Received: from classea.com.br (correio.infonet.com.br [200.241.48.1]) by hub.org (8.9.2/8.9.1) with SMTP id JAA88950 for ; Sat, 6 Mar 1999 09:29:23 -0500 (EST) (envelope-from carvalho@inet.classea.com.br) Received: from [200.241.48.221] by classea.com.br (NTMail 3.02.13) with ESMTP id ta676357 for ; Sat, 6 Mar 1999 11:36:45 +0100 Date: Sat, 6 Mar 1999 10:32:29 +0000 (GMT) From: Fernando Carvalho X-Sender: carvalho@localhost To: Mauricio Carvalho de Oliveira cc: pgsql-sql@hub.org Subject: [SQL] Relations In-Reply-To: <36D1B4C6.9F388890@dt.fee.unicamp.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I'm novice in postgresSQL. How do you have a relations with two tables? Table 1 -> cod int 4 index descrition varchar(30) price init 4 Table 2 -> order varchar(8) cod int 4 quant ini 4 I'm a expected one select with result: order | descrition | quant | price | total(price * quant)