How can I fetch recursive data from two seperate tables using single mysql 5 query (without using stored procedures)?
See Example attached (as image), how a source has multiple notes and notes can have multiple sources:
This event has a source and two notes. The source (Book of Tel Aviv Memorials in this case) and there is a note on that source (This is a great book) and a source on that note (Interview with George Singh). There are also one note on the source - Interview with George Singh (Note: It isn't certain that he was really born in 1928), which further has source related to it (Source: [+] Interview with Jeremiah Quizzle)