Left join producing wrong result
|
cid |
ctype1_name |
phone |
ctype2_name |
phone |
ctype3_name |
phone |
1 |
1001 |
NULL |
NULL |
Joe |
NULL |
NULL |
NULL |
2 |
1001 |
NULL |
NULL |
NULL |
NULL |
Jack |
6547893214 |
3 |
1001 |
NULL |
NULL |
NULL |
NULL |
Jack |
9878445623 |
4 |
1001 |
NULL |
NULL |
Joe |
9874563210 |
NULL |
NULL |
5 |
1001 |
Tim |
1234567890 |
NULL |
NULL |
NULL |
NULL |
6 |
1001 |
Tim |
6547896125 |
NULL |
NULL |
NULL |
NULL |
7 |
1002 |
NULL |
NULL |
Smith |
NULL |
NULL |
NULL |
8 |
1002 |
NULL |
NULL |
NULL |
NULL |
Jill |
6547893214 |
9 |
1002 |
NULL |
NULL |
NULL |
NULL |
Jill |
9878445623 |
10 |
1002 |
NULL |
NULL |
Smith |
9874563210 |
NULL |
NULL |
11 |
1002 |
Jane |
1234567890 |
NULL |
NULL |
NULL |
NULL |
12 |
1002 |
Jane |
6547896125 |
NULL |
NULL |
NULL |
NULL |
|
λ
.NET NoSQL database for rapid development
|