From: | Alex <alex(at)meerkatsoft(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | "Andrew L(dot) Gould" <algould(at)datawok(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Question Join/Subselect |
Date: | 2003-08-28 13:10:38 |
Message-ID: | 3F4DFF4E.6090600@meerkatsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the help.
Alex
Richard Huxton wrote:
>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;
>>>
>>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex | 2003-08-28 13:20:55 | Arrays and Indices / Foreign Keys |
Previous Message | Oleg Bartunov | 2003-08-28 13:01:34 | Re: tsearch: how to get a list of stopwords? |