Benoit Lion writes:
> select nmn_can,pre_can,dat_nai,dci_sai,cnd.cod_spe,cnd.cod_pa1,decision
> , cnd.cod_pa2
> >from cnd,cnd_grp, decision where cnd.cod_eta='0731043M'
> and cnd.num_can=cnd_grp.num_can and cnd_grp.typ_grp='D'
> and cnd_grp.dci_sai=decision.cod_dec
>
> union
>
> select nmn_can,p
In postgres 7.0.2 i have an "order by" with column names like this :
select colonne1,colonne2 from A
union
select colonne1,colonne2 from B
order by colonne1,colonne2
In postgres 7.1 this simple example works. But with i have a more
difficult select that doesn't work, and i had to use
