Hi,
I am trying to create a view out of table A and B by combining them . both tables doesn't have any common columns except created date and created by .
I would like to combine both these tables . can you please is it possible in Appian MySql ?
Table A
Fruit_ID
Fruit
Created Date
Created By
1
Apple
12/19/2018
John
Orange
Table B
Veg_ID
Vegetables
12
Carrot
1/23/2019
Mark
23
Zucchini
1/23/2018
Output View
NULL
2
Discussion posts and replies are publicly visible