case statement for combining same columns across multiple tables

Sorry not fully clear

Can you post what would be output you require for typical sample data. Please post some numerical values instead of id_a etc to avoid confusion.

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page