Populating hard coded values for unmatched values between the fields

[Anonymous]

Populating hard coded values for unmatched values between the fields .

For example:

Below is the table there are values for  Acct_number, portfoilo_number, paid_to_pt_sys_no,portfo_sys_no. 

for desired output table:

for only matched values between the paid_to_pt_sys_no,portfo_sys_no fileds i need get portfoilo_number and for rest i need shown "UNKNOW" . As shown below 

ACCT_NUMBER	PORTFOLIO_SYS_NO	ACCT_PAID_TO_R
110006004	45174	110006004.2
110484607	20856	110484607.2
110386307	10106	UNKNOW
110386307	10155	UNKNOW
110458601	819	UNKNOW

Thanks,

[amitchandak]

Column

if(paid_to_pt_sys_no=portfo_sys_no,portfo_no&"","UNKNOWN")

[Anonymous]

all the three tables are mapped to primary key .. 

[Anonymous]

Thanks for respone ..

Based the 3 tables , the input table has been build . Account_number from  account table, paid_to from transaction table, other two fields from portfolio table . it a direct mode .  Can you now help me on this ..