Page Comparison

select SELECT 	pay.PIN,
	       p01.Name,
	
       persorg.name as              AS Organization,
	
       pay.accountdim2 as            AS VesOrgID,
	isnull
       ISNULL(ves.name, 'N/A') as   AS 'Vessel Name',
	case when
       CASE 
            WHEN pay.ACCOUNTDIM3 isIS NULL orOR pay.ACCOUNTDIM3 = '' thenTHEN 'N/A'
		else
            ELSE pay.ACCOUNTDIM3
	end       END 'Department',
	isnull
       ISNULL(CAT.NAME, 'Other')  asAS 'Category',
	
       pay.CALCULATEDAMOUNT1      asAS 'Amount',
       	pay.periodeused as           AS Period,
	       CONVERT(VARCHAR, PAY.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
	case when
       CASE 
            WHEN pay.ACCOUNTNOOFCALCAMOUNT1<>ACCOUNTNOOFCALCAMOUNT1 <> '' THEN pay.ACCOUNTNOOFCALCAMOUNT1 + ' - ' + acc.ACCOUNTTEXT
		 when
            WHEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1<>ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '' THEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1 + ' - ' + acc.ACCOUNTTEXT
    end   END 'Account No',
	case when pay.ACCOUNTNOOFCALCAMOUNT1<>0
       CASE 
            WHEN pay.ACCOUNTNOOFCALCAMOUNT1 <> '' THEN 'DEBIT'
		 when
            WHEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1<>0ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '' THEN 'CREDIT'
		 else
            ELSE                     'N/A'
    end   END 'Account type',
	
       pay.rank as Rank,
	pay.currencyforpayment as                   AS RANK,
       pay.currencyforpayment     AS 'Payment Currency ',
	
       p01.client                    numorgid,
	       p01.employmentstartdate,
	
       p01.employmentenddate
fromFROM   pw001pay pay
left join
       LEFT JOIN pw001p01 p01 on
            ON  p01.pin = pay.pin and CALCULATEDAMOUNT1<>0
left join
            AND CALCULATEDAMOUNT1 <> 0
       LEFT JOIN pworg ves on
            ON  ves.numorgid = pay.accountdim2
left join       LEFT JOIN pyety001 ec on
            ON  ec.entrycode = pay.entrycode
left join
       LEFT JOIN pworg persorg on
            ON  persorg.numorgid = p01.client
    left join   LEFT JOIN PW001C117 CAT on
            ON  ec.CATEGORY = CAT.SEQUENCENO
and            AND pay.ENTRYCODE = ec.ENTRYCODE
left join
       LEFT JOIN PY001ACC ACC on 
            ON  (ACC.ACCOUNTNO = pay.ACCOUNTNOOFCALCAMOUNT1) orOR (acc.ACCOUNTNO = pay.ACCOUNTNOOFCALCAMOUNTCREDIT1)
WHERE  CALCULATEDAMOUNT1 <> where0 CALCULATEDAMOUNT1<>0