return the result with respect to the other columns value came equal

[Eben]

[Eben]

[glilienfield]

@Eben  do you have a specific question?  

[mburrell]

I believe they want to know how to return just the 'new_issue' column when one of the other columns (co or cos) are equal. @Eben can you confirm and/or explain further?

[glilienfield]

Ok, I will assume the requirement is to return the 'new_issue' column only when 'cos equals co'. For this case, replace line 6 with the following code:

with p.nest_issue as new_issue, co, cos
where co = cos
return p.nest_issue

[Eben]

thank you @glilienfield its working

[Eben]

yes u are right.

[glilienfield]

that is great.  Can you mark the response as a solution so everyone knows the thread has been closed?   thanks...