I have one table say A, with location { delhi, patna, kanpur} and it's location id is {1,2,3} . I also have another table say locationjourney in which a person xyz travels from location id 1 to 3 and another person abc from 2 to 3. Now I need to display: person name(xyz)and location from ( delhi) to( kanpur)
Discussion posts and replies are publicly visible
What is your actual question? Is it "How does my data model need to be designed?" Or is it "How do I retrieve the relevant data from the tables and display it?". Or something else?