fred Koizar [mailto:[EMAIL PROTECTED]
> Envoye : lundi 16 juin 2003 16:40
> A : Nicolas JOUANIN
> Cc : [EMAIL PROTECTED]
> Objet : Re: [SQL] Let join syntax
>
>
> On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN"
> <[EMAIL PROTECTED]> wrote:
> >fro
On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN"
<[EMAIL PROTECTED]> wrote:
>from
>coh x0 , cpy x1 ,bra x2 ,
>cur x3 ,tad x4 LEFT OUTER JOIN sec x5 on x5.thr_id=x4.thr_id AND
>x5.usr_id=x0.usr_id AND x5.bra_id = x0.bra_id AND x5.dpr_id = x0.dpr_id,
>dpr x6 where ((x0.cpy_i
Manfred Koizar <[EMAIL PROTECTED]> writes:
> On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN"
> <[EMAIL PROTECTED]> wrote:
>> from
>> coh x0 , cpy x1 ,bra x2 ,
>> cur x3 ,tad x4 LEFT OUTER JOIN sec x5 on x5.thr_id=x4.thr_id AND
>> x5.usr_id=x0.usr_id AND [...]
>>
>> Unfortunatelly, postgres
On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN"
<[EMAIL PROTECTED]> wrote:
>from
>coh x0 , cpy x1 ,bra x2 ,
>cur x3 ,tad x4 LEFT OUTER JOIN sec x5 on x5.thr_id=x4.thr_id AND
>x5.usr_id=x0.usr_id AND [...]
>
>Unfortunatelly, postgres returns me the following error :
> Error: ERR
Hi,
I've a problem with the following query. I want to left join table sec (x5)
with x0, and x4. I try the following query :
select x0.coh_agent ,x0.bra_id ,x0.dpr_id ,x0.usr_id ,x0.csc_id
,x0.spp_id ,x0.csc_id_inv ,x0.coh_doc_inv ,x0.coh_d_inv ,
x0.coh_process ,x0.coh_doc_main ,x0.coh
