Let’s say I have the following 3 Tables:-
b_id (Foreign Key from Table B)
c_id (Foreign Key from Table C)
Is there a way in which while fetching the rows of Table A, I can also fetch the related rows from Table C? I know I can fetch the rows from Table B by using the related property.
But due to normalization issues my data is lying in table C, which I need.
Since I can’t fetch it directly now, I have to fire additional query based on Table B.
I know there are options like View, Stored Proc, SQL Query, Server Side filter that I may be able to use.
However, what I am looking for is to fetch C based on the related field using the REST API call.
Help is appreciated !