passenger
p_id amount Country
1 300 USA
2 500 India
3 600 Japan
4 200 China
5 450 Mexico
country_list
RECORD Coutry_name_cd
1 Mexico
2 Japan
final output
new_table
p_id amount Country1 600 Japan2 450 Mexico
p_id amount Country
1 600 Japan
2 450 Mexico
passenger p_id amount Country 1 300 USA 2 500 India 3 600 Japa
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
passenger p_id amount Country 1 300 USA 2 500 India 3 600 Japa
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!