My requirement is : We have two table A(Customer) and B(Restaurant) ,Table A has column (X coordinates and Y coordinates ) geographic location of Customer and Table B has column ((X coordinates and Y coordinates ) geographic location of Restaurant .
I would like create 1 recordset of data from both table having the all four columns . I tried with Union but it failed , as there is no link between both tables .So we can't do it using reconciliation . Please let us know if is there any workaround for it .
Please let me know if you need more detail on it .