| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Alex <alex(at)meerkatsoft(dot)com>, "Andrew L(dot) Gould" <algould(at)datawok(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question Join/Subselect |
| Date: | 2003-08-28 09:00:11 |
| Message-ID: | 200308281000.11981.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 28 August 2003 08:20, Alex wrote:
> Andrew,
> thanks for the help. The query actually works. However if I try to
> create a view then the sever complains
>
> Create Tabe: attribute "actualcode" duplicated;
Alias the output names:
... Table2.ActualCode as actual1, Table3.ActualCode as actual2 ...
> Any Ideas on how to get around that ?
>
> Alex
>
> Andrew L. Gould wrote:
> >On Wednesday 27 August 2003 10:28 pm, Alex wrote:
> >
> >I'm not sure how to handle the space in the table names. If there weren't
> > any spaces in table names, the following should work:
> >
> >select Table1.userName, Table2.ActualCode, Table3.ActualCode
> >from Table1, Table2, Table2 as Table3
> >where Table1.refCode1 = Table2.refCode and Table1.refCode2 =
> > Table3.refCode;
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-28 09:04:13 | Re: postgres vs mysql |
| Previous Message | Andrew L. Gould | 2003-08-28 08:58:04 | Re: Question Join/Subselect |