From: | Fernando Carvalho <carvalho(at)inet(dot)classea(dot)com(dot)br> |
---|---|
To: | Mauricio Carvalho de Oliveira <carvalho(at)dt(dot)fee(dot)unicamp(dot)br> |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | [SQL] Relations |
Date: | 1999-03-06 10:32:29 |
Message-ID: | Pine.LNX.3.96.990306102522.521F-100000@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 1999-03-06 14:14:04 | Re: [SQL] How to sort date |
Previous Message | Martin Möderndorfer | 1999-03-06 08:41:50 | ER, OMT chart of a database |