How do I do a full join in gnumeric?

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