Forum Discussion
merge two table with full outer join values
Hi Anonymous
(1)You can use Append function in Query Editor .Append two tables and return a new table like this :
(2)Delete the duplicate rows with null in Ct val. And then replace the null value with 0 .
(3)Close & Apply to Desktop view , and the result is as shown :
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I haveing two table i want to mapping table 2 value to table 1 .some values different that values also return . I
TABLE 1 :
LOCATION PRODUCT M1 M2
1A04 DA001145 5 6
1B04 DA001145 15 16
1D04 DA001145 35 76
TABLE 2 :
LOCATION PRODUCT ACT VALUE
1C04 CA001145 5 1
1B04 DA001145 15
1K04 KA001145 45
i want to return output matched rows and unmatched row also like
LOCATION PRODUCT M1 M2 ACT value
1A04 DA001145 5 6 0
1B04 DA001145 15 16 15
1D04 DA001145 35 76 0
1C04 CA001145 0 0 5 1
1K04 KA001145 0 0 45