I have 2 tables
Table 1 is H and is a Header
Table 2 Is B and Is a Body
this is Table 1 : H
ACCID | AccName |
---|---|
1 | Acc1 |
2 | Acc2 |
3 | Acc3 |
this is Table 2 : B
ID | AccID_receive | AccID_payment |
---|---|---|
1 | 1 | 2 |
2 | 1 | 2 |
3 | 2 | 3 |
I WNANT this Result
ID | AccID_receive | AccID_payment |
---|---|---|
1 | Acc1 | Acc2 |
2 | Acc1 | Acc2 |
3 | Acc2 | Acc3 |
Here what I Have tried
Select B.ID,
H.AccName
From B
left join H
on B.AccID_receive = H.AccID
But the result is Not Ok with me I want the name of Accname in the 2 Column