How do I do a full join in gnumeric?

[刘祥 <xiang-l vip 163 com>]

I often encounter such a problem. There are two tables sharing the same 
key ID, but they do have different num of records. But some of records 
do not appear in another table. I need to merge them into a whole table 
with all fileds where the missing values are replaced by blank or N/A.

For exmaple

table1
======
ID      Name
1       Andy
2       Jack

table2
======
ID      Phone
1       111
3       333

||
||
VV

merged_table
============
ID      Name    Phone
1       Andy    111
2       Jack    
3               333

BTW, Excel provides SQL support, so I thought I could use FULL OUTER 
JOIN Syntax[1] to do this.

[1] FULL OUTER JOIN Syntax: https://www.w3schools.com/sql/sql_join_full.asp