🚀 go-pugleaf

Thanks! It seems to work now!
But I'm a bit confused: now my previous select seems to work as well !!!

So I have just one question:
I guess that in a master/detail relationship all the parameters in the
SelectSQL of the detail table that has the same name that existing fields in
the master table, are filled automatically with the master table data.

Is that correct???

Sergio.


"amita" <amita@agnisoft.com> escribi� en el mensaje
> Try
>
> select
>     oc.*,
>     des.NOMBRE,
>     ar.CODIGO, ar.CODIGO_BARON,  ar.CODIGO_S_PROV
>  from
>     ORDEN_COMPRA_1 oc inner join DESCRIPCIONES des on (oc.ID_ARTICULO =
> des.ID) inner join
>     ARTICULO ar on (oc.ID_ARTICULO = ar.ID)
>  where
>   oc.NUMERO = :NUMERO  and
>   des.ID_TIPO_DES = ( Select ID_TIPO_DES  from MainPurChaseOrderTable
>  where MainPurChaseOrderTable.NUMERO =:NUMERO)
>
> --
> Amita
> Agnisoft, India
>
> "Sergio Gonzalez" <shg@sion.com> wrote in message
> >
> > select
> >    oc.*,
> >    des.NOMBRE,
> >    ar.CODIGO, ar.CODIGO_BARON,  ar.CODIGO_S_PROV
> > from
> >    ORDEN_COMPRA_1 oc,
> >    DESCRIPCIONES des,
> >    ARTICULO ar
> > where
> >    oc.NUMERO = :NUMERO  and
> >    oc.ID_ARTICULO = des.ID and
> >    oc.ID_ARTICULO = ar.ID   and
> >    des.ID_TIPO_DES = :ID_TIPO_DES