Questions

SQL Select Statement?

Tags:
+
0 Votes
Locked

SQL Select Statement?

sundayose
Voucher Table
V_ID Str_Barcode C_ID Int??_VSP_ID
1 HB001 1 13
2 HB003 2 20

VSP Table
Int_VSP_ID VSP_Name
13 Kamukama
20 Bamu

Client Table
C_ID Str_CLientN V_ID
1 Janet B 20
2 Joseph N 15

Village Table
V_ID Str_VillageN
15 Beni
20 Butembo

Distributor Table
D_ID Str_Distributor N V_ID
1 Musa 15
2 John 20

Required Result
Str_Barcode Str_VSPN Str_ClientN Str_VillageN Str_DistributorN
HB001 Kamukama Janet B Beni Musa
HB003 Bamu Joseph N Butembo John