Postgres Pro
Downloads
Home   >   mailing lists

[SQL] Relations - Mailing list pgsql-sql

From Fernando Carvalho
Subject [SQL] Relations
Date
Msg-id Pine.LNX.3.96.990306102522.521F-100000@localhost
Whole thread Raw
In response to Problem with HAVING clause  (Mauricio Carvalho de Oliveira <carvalho@dt.fee.unicamp.br>)
List pgsql-sql
Tree view 
  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)

pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [SQL] How to sort date
Next
From: Tom Lane
Date:
Subject: Re: [SQL] CREATE TABLE (fwd ): again!