HI I have been unable to duplicate this query.
It uses 5 files it matches from the orderhistory file to customer, and
shipping, invoice history and address files.
OHENT# EQ ADENT#
OHSFX# EQ ADSFX#
OHORD# EQ IDORD#
OHENT# EQ ACENT#
OHSFX# EQ ACSSF#
has some record selects and sorting, no problems so far. Does totals on qty
shipped and $shipped.
Does break levels on 9 fields. this is the part I cannot translate. then
puts the data to a temp file.
I am not getting the same number of records no matter what. am sure the
issue is how to code this Break in SQL.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.