Hi shield_21-san

Henji(Reply) Arigatou Gozaimashita !

By using Your hint of using row_number I changed my code as follows,

SELECT COALESCE(t1.file_no,t2.file_no) AS file_no,

COALESCE(t1.item_no,t2.item_no) AS item_no,

t1.name_1,t2.name_1

FROM (SELECT ROW_NUMBER() OVER (PARTITION BY file_no,item_no ORDER...

Hi SSC Rookie

Assume that tables are already populated, then how can i achieve the same results ?

Thanks in Advance

I tried the code and it worked.

Thanks a lot !

One more thing, assume that tbl1 & tbl2 are already populated then how this result can be achieved ?