I need to join the two tables in the following way.. using mysql

Asked Aug 21 '20 at 08:34

Active Aug 21 '20 at 08:40

Viewed 24 times

Table 1

Country Export 
China     90
India     80   
Korea     40

Table 2

Country Import 
China     40
India     30   
Japan     50

Result

Country Export Import
China     90     40
India     80     30
Korea     40     0
Japan     0      50

edited Aug 21 '20 at 08:40

Strawberry

asked Aug 21 '20 at 08:34

Arjunkumar

This is a full outer join. Examples of replicating this in MySQL are discussed widely. – Strawberry Aug 21 '20 at 08:41
1

use FULL OUTER JOIN and then COALESCE to replace the nulls with 0. – Gabriel Durac Aug 21 '20 at 08:42

0 Answers0