Page Comparison

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

where CALCULATEDAMOUNT1<>0WHERE  CALCULATEDAMOUNT1 <> 0