🚀 go-pugleaf

On Mon, 30 Dec 2002 17:47:04 -0300, "Sergio Gonzalez" <shg@sion.com>
wrote:

>Hi there!
>I need to join 3 tables.
>Does this SELECT makes any cense? It don't work anyway!

It makes sense if what you want is all of the rows from oc that have
matching rows in both des and ar and that have the specified oc.numero
and des.id_tip_des.

"It don't work" does not tell us very much. You need to provide a much
more detailed explanation of your problem if you want help.

>
>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
>
>DESCRIPTION OF THE TABLES:
>
>ORDEN_COMPRA_1 = Items of purchase orders (it is the detail table of the
>main purchase orders table)
>DESCRIPCIONES = It has different kind of descriptions for each item in the
>items table
>ARTICULO = Items table
>
>The parameter :NUMERO is passed from the master table.
>I'm not sure if the parameter :ID_TIPO_DES its being passed automatically
>from the master table also.
>(it has a field named ID_TIPO_DES)
>
>Many Thanks!
>
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)