The query below works perfect... except that it returns everything 6 times. Each cost in TableA will be shown 6 times. TableB is for Invoices and TableA contains the line items fo those invoices.
Each invoice will have a unique Date and SEQ... each line item of that invoice will have the same Date and SEQ.
Any thoughts here?
LEFT OUTER JOIN
TableA.DATE=TableB.DATE AND TableA.SEQ=TableB.SEQ
TableA.STATUS = 'Open'