How to create a Pointer feilds. I have created a feilds in each tables and added a column and value which is same as from other table which needs to be mapped. If I can write a SQL with where clause then I can map these feilds and get the values.
I have three tables in the Database in Appery and I want to create a Service which should get data from all three tables in a single service.
Is it possible to create a Database View? Any other options.