Page Comparison

SELECT pyh.PIN,
       p01.Name,
       persorg.name               AS Organization,
       pyh.accountdim2            AS VesOrgID,
       ISNULL(ves.name, 'N/A')    AS 'Vessel Name',
       CASE 
            WHEN pyh.ACCOUNTDIM3 IS NULL OR pyh.ACCOUNTDIM3 = '' THEN 'N/A'
            ELSE pyh.ACCOUNTDIM3
       END 'Department',
       ISNULL(CAT.NAME, 'Other')  AS 'Category',
       pyh.calculatedamount1 'Amount',
       pyh.periodeused            AS Period,
       CONVERT(VARCHAR, pyh.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
       CASE 
            WHEN pyh.ACCOUNTNOOFCALCAMOUNT1 <> '' THEN pyh.ACCOUNTNOOFCALCAMOUNT1 + ' - ' + acc.ACCOUNTTEXT
            WHEN pyh.ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '' THEN pyh.ACCOUNTNOOFCALCAMOUNTCREDIT1 + ' - ' + acc.ACCOUNTTEXT
       END 'Account No',
       CASE 
            WHEN pyh.ACCOUNTNOOFCALCAMOUNT1 <> '0' THEN 'DEBIT'
            WHEN pyh.ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '0' THEN 'CREDIT'
            ELSE                     'N/A'
       END 'Account type',
       pyh.rank                   AS RANK,
       pyh.currencyforpayment     AS 'Currency for Payment',
       p01.client                    numorgid,
       p01.employmentstartdate,
       p01.employmentenddate
FROM   pw001pyh pyh
       LEFT JOIN pw001p01 p01
            ON  p01.pin = pyh.pin
       LEFT JOIN pworg ves
            ON  ves.numorgid = pyh.accountdim2
       LEFT JOIN pyety001 ec
            ON  ec.entrycode = pyh.entrycode
       LEFT JOIN pworg persorg
            ON  persorg.numorgid = p01.client
       LEFT JOIN PW001C117 CAT
            ON  ec.CATEGORY = CAT.SEQUENCENO
            AND pyh.ENTRYCODE = ec.ENTRYCODE
       LEFT JOIN PY001ACC ACC
            ON  (ACC.ACCOUNTNO = pyh.ACCOUNTNOOFCALCAMOUNT1) OR (acc.ACCOUNTNO = pyh.ACCOUNTNOOFCALCAMOUNTCREDIT1)
WHERE  CALCULATEDAMOUNT1 <> 0