🚀 go-pugleaf

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)

The subquery here  gets the ID_TIPO_DES (Spanish/ English) from the main
Purchase order given the
Purchase Order No

--
Amita
Agnisoft, India

"Sergio Gonzalez" <shg@sion.com> wrote in message
news:3e111bfd$1@newsgroups.borland.com...
> Thanks for replying Bill!
> I'll try to put it clear:
>
> the SELECT statement I've posted is supposed to be the SelectSQL of my
> Purchase_Orders_Items table. It is the detail table of other that has the
> fields NUMERO and ID_TIPO_DES. I insist in this matter, because I know
that
> the master table will pass the parameter for NUMERO (that's the PK) but:
>
> it will pass the parameter for ID_TIPO_DES ?? if doesn't here I have my
> first problem. This field represent the "kind of description" of the items
> in all the lines of the purchase order (I.e.: all the descriptions may be
in
> English or Spanish) The user types it when he creates a new purchase
order.
>
> I need to show all the selected fields in a dbGrid. But I only see the
> fields that belongs to the main table (ORDEN_COMPRA_1) the others remain
> blank. Actually when I pull down the listbox in order to choose the field
> name in the FieldName property of the column property of the dbGrid I see
> only the fields of ORDEN_COMPRA_1.
>
> I'm not using the JOIN clause because I don't know how to use it with more
> than 2 tables.
>
> Here I post the select again:
>
> 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
>
>
> Thanks again!
>
>
> Sergio
>
>
>