🚀 go-pugleaf

Is there a way to merge the data from two datasets into a single dataset.

For example I have two tables:

Table 1                                                      Table 2
--------------------------------------                    ------------------
---------------------------------
ID        Name        Phone No                    ID    Name    Mob Phone No
Make
--------------------------------------                    ------------------
---------------------------------
001     Fred          0123456                     002  James  M324531
Nokia
003     Tom           0654321                     004  Mark     M324532
Siemens

But I want to merge the data so that all columns are visible but any value
that isn't relevant for a column is blank (>>>> represents blank in the
example). So the resulting set is:

ID        Name        Phone No    Mob Phone No        Make
----------------------------------------------------------------------------
-----
001     Fred          0123456      >>>>>>>>>>>>       >>>>>>>
002     James      >>>>>>>      M324531                  Nokia
003     Tom          0654321      >>>>>>>>>>>>        >>>>>>>
004     Mark         >>>>>>>      M324531                  Siemens

The result set can be read only if needs be.

Thanks


Neil