I have three table in my database as shown below
Voucher Table
V_ID Str.Barcode C_ID
1 HB001 1
2 HB003 2
Client Table
C_ID St_CLientN V_ID
1 Janet B 20
2 Joseph N 15
Village Table
V_ID Str_VillageN
15 Beni
20 Butembo
I need to get a result like this
HB001 Janet B Beni
HB003 Joseph N Butembo
Thanks for your contribution.