Draft: Joining multiple tables

[HideBa]

Leader

@

User story

The user wants to handle multiple data in separate tables. For example, if you have data with country_code, country_name, population and data with country_code, area, you want to join these data with country_code. By doing so, we can create new data from multiple data. In this case, we can use outer join, inner join, or left/right joins as in RDBMS, but in the first phase, we need to support at least the left outer join.

Requirements

User can

• choose which tables will be joined
• choose which field will be the foreign key

Design file

Testing list

• When OO is
  • If you input "XXX", it should show "YYY"