0

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

Ahmed Saif
  • 125
  • 6

0 Answers0