| 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: | Whole Thread | Raw Message | 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 |