passenger p_id amount Country 1 300 USA 2 500 India 3 600 Japa
Posted: Thu Jul 14, 2022 2:13 pm
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
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