Zeoslib Portal

[syntax="sql"]SELECT
nikebarcode.Code1,
nikebarcode.Code2,
nikebarcode.Shipment,
nikebarcode.Package,
shipmentinfo.week,
shipmentinfo.trailer,
shipmentinfo.Shipment,
shipmentinfo.Customer,
shipmentinfo.city,
shipmentinfo.no,
shipmentinfo.country,
shipmentinfo.Name,
shipmentinfo.Colli,
shipmentinfo.Weight,
shipmentinfo.Unit,
shipmentinfo.ProductName,
shipmentinfo.DeliveryDate,
shipmentinfo.time,
nikebarcode.MISSING,
shipmentinfo.Waybilldate,
shipmentinfo.WaybillCreated,
shipto.ID,
shipto.CustomerCode,
shipto.DeliveryName,
shipto.DeliveryAddress,
shipto.DeliveryAddress2,
shipto.DeliveryDistrict,
shipto.DeliveryCity,
shipto.DeliveryPostCode,
shipto.Deliverycode,
billto.ID,
billto.CustomerCode,
billto.CustomerName,
billto.Address,
billto.Address2,
billto.District,
billto.City,
billto.Postcode,
billto.TaxOffice,
billto.TaxNumber
FROM
billto,
shipto,
shipmentinfo,
nikebarcode
WHERE
(nikebarcode.code2 = 309) AND
(shipmentinfo.shipment = nikebarcode.shipment) AND
(shipmentinfo.customer = shipto.customercode) AND
(billto.customercode = shipto.customercode)[/syntax]

Thats my query.. I want to add waybill number to the result of this query.
But I have to control shipment number and customer code when I am adding waybill numbersto the query. For example

I have a report there is a record limit perpage its 15.then if customercode is same with the prior i want to give same waybill number to both of the shipments till that recorcount comes to 15 after than waybill number must be increase by 1...

I wish its clear.. Thanks..