Minigrip de México

SELECT

    IdClaveGP        = tblLinkInventorySequentials.CompoundSecuential,

    NumParteInterna  = tblOrderDetail.InternalPartNbr,

    IdCliente        = tblOrder.CustomerNumber,

    Cliente          = tblCustomer.CustomerName,

    OrdenVentaDef    = tblOrderDetail.OrderNumber,

    OrdenDetalleDef  = tblOrderDetail.OrderDetailNumber,

    TipoProducto     = tblOrderDetail.ProductType,

    EstiloProducto   = tblOrderDetail.ProductStyle,

    UndVta           = tblOrderDetail.CustomerUOM,

    Activo           = tblOrderDetail.Active,

    TipoTransaccion  = tblOrder.TransactionType

FROM 

    [TORI-FLEX].dbo.tblOrderDetail

        INNER JOIN

    [TORI-FLEX].dbo.tblOrder

        ON tblOrderDetail.OrderNumber = tblOrder.OrderNumber

        INNER JOIN

    [TORI-FLEX].dbo.tblCustomer

        ON tblOrder.CustomerNumber = tblCustomer.CustomerNumber

        INNER JOIN

    [AccountingLink].dbo.tblLinkInventorySequentials

        ON tblOrderDetail.InternalPartNbr = tblLinkInventorySequentials.InternalPartNbr

WHERE

    tblOrderDetail.InternalPartNbr = '5-7795-A ENV IND 27.5CM ROSA K. LANGOSTA' AND 

    tblOrderDetail.SeqNumber = 0