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') as AS 'Category',
	       pay.CALCULATEDAMOUNT1 as      AS '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,
	                   AS RANK,
       pay.currencyforpayment as    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  LEFT joinJOIN 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<>0WHERE  CALCULATEDAMOUNT1 <> 0