etmccarthy13
Baseband Member
- Messages
- 79
- Location
- Fort Wayne, IN USA
Ok Im not sure whats wrong with this Query but it is duplicating entries. One with the info im wanting and one with out the info... I want to get rid of the high lighted lines... Any Help is appreciated
BElow is SQL Statement and a screen shot of the OutPut
SQLSTART:
select '' as Blank,
ShipmentOrder.DocumentDate,
'' as Time,
ShipmentOrder.WarehouseBOLNumber,
'' as PartnerFunction,
'' as Partner,
ShipmentOrder.CustomerPONumber as CustomerPONumber,
ShipmentOrder.CustomerOrderNumber as CustomerOrderNumber,
ShipmentOrderDetail.CustomerLineNumber as RefItm,
ShipmentOrderDetail.PoLineNumber as Item,
ShipmentOrderPick.WarehouseSku,
ShipmentOrderPick.LotReferenceTwo as BatchNumber,
ShipmentOrderPick.Qty as QtyShipped,
'ZZC' as UOM, ShipmentOrderPick.FromPalletId as ExtShipUnitID
from ShipmentOrder, ShipmentOrderPick, ShipmentOrderDetail
where ShipmentOrder.OrderNumber = $P{OrderNumber}and
ShipmentOrder.WarehouseName = $P{WarehouseName} and
ShipmentOrder.FacilityName = $P{FacilityName} and
ShipmentOrder.CustomerName = $P{CustomerName} and
ShipmentOrderPick.OrderNumber = ShipmentOrder.OrderNumber and
ShipmentOrderPick.WarehouseName = ShipmentOrder.WarehouseName and
ShipmentOrderPick.FacilityName = ShipmentOrder.FacilityName and
ShipmentOrderPick.CustomerName = ShipmentOrder.CustomerName
Group by
ShipmentOrder.DocumentDate,
ShipmentOrder.WarehouseBOLNumber,
ShipmentOrder.CustomerPONumber,
ShipmentOrder.CustomerOrderNumber,
ShipmentOrderPick.WarehouseSku,
ShipmentOrderPick.LotReferenceTwo,
ShipmentOrderPick.FromPalletID,
ShipmentOrderDetail.CustomerLineNumber,
ShipmentOrderDetail.PoLineNumber,
ShipmentOrderPick.Qty
Order By ShipmentOrderPick.WarehouseSku
SQLEND:
BElow is SQL Statement and a screen shot of the OutPut
SQLSTART:
select '' as Blank,
ShipmentOrder.DocumentDate,
'' as Time,
ShipmentOrder.WarehouseBOLNumber,
'' as PartnerFunction,
'' as Partner,
ShipmentOrder.CustomerPONumber as CustomerPONumber,
ShipmentOrder.CustomerOrderNumber as CustomerOrderNumber,
ShipmentOrderDetail.CustomerLineNumber as RefItm,
ShipmentOrderDetail.PoLineNumber as Item,
ShipmentOrderPick.WarehouseSku,
ShipmentOrderPick.LotReferenceTwo as BatchNumber,
ShipmentOrderPick.Qty as QtyShipped,
'ZZC' as UOM, ShipmentOrderPick.FromPalletId as ExtShipUnitID
from ShipmentOrder, ShipmentOrderPick, ShipmentOrderDetail
where ShipmentOrder.OrderNumber = $P{OrderNumber}and
ShipmentOrder.WarehouseName = $P{WarehouseName} and
ShipmentOrder.FacilityName = $P{FacilityName} and
ShipmentOrder.CustomerName = $P{CustomerName} and
ShipmentOrderPick.OrderNumber = ShipmentOrder.OrderNumber and
ShipmentOrderPick.WarehouseName = ShipmentOrder.WarehouseName and
ShipmentOrderPick.FacilityName = ShipmentOrder.FacilityName and
ShipmentOrderPick.CustomerName = ShipmentOrder.CustomerName
Group by
ShipmentOrder.DocumentDate,
ShipmentOrder.WarehouseBOLNumber,
ShipmentOrder.CustomerPONumber,
ShipmentOrder.CustomerOrderNumber,
ShipmentOrderPick.WarehouseSku,
ShipmentOrderPick.LotReferenceTwo,
ShipmentOrderPick.FromPalletID,
ShipmentOrderDetail.CustomerLineNumber,
ShipmentOrderDetail.PoLineNumber,
ShipmentOrderPick.Qty
Order By ShipmentOrderPick.WarehouseSku
SQLEND: