How we can achieve outerright join in form?
I have one form having 2 grids and 2 different datasources.
Grid A binded with Datasource1 ( regular Table)
Gird B binded with Datasource2 ( Temp Table)
Datasource2 table has more number of records as compared to Datasource1 ( few un-match records ).
I need to show all matching records in Grid A and also unmatch too.
Inner join bring only common records and outer join bring common records as datasource1 has lesser records as compared to datasource2.
Since datasource2 is temp table, joining condition has to used else linkPhysicalTableInstance fails.
any suggestions?
*This post is locked for comments