There is a Customer table that has a list of customers and Gift Voucher table that has list of gift vouchers. No of vouchers is less than No of customers. Customer table has one column Customer_Id. Voucher has one column Voucher_id.
Customer_Id
Abhinash
Vipin
Mahesh
Bijoy
Bhabani
Ashutosh
Voucher_Id
ABXFH
SDFGH
ERTYY
PPLKM
Develop a SQL query that will assign one voucher to one customer until all vouchers are exhausted and populate the table as shown.
Customer_Key Gift Voucher Key
Abhinash ABXFH
Vipin SDFGH
Mahesh ERTYY
Bijoy PPLKM
Bhabani -
Ashutosh -