error : The multi-part identifier couldnt be bound.

Hello Shan,

Can you please the DDL for the table(s) + some sample data + expected output? Without no one can quess, which columns are in which table, like here the column "id".

---

Olaf Helper

Blog Xing