I have 29 tables,currently all with the same structure. These are tables containing differing versions of the Bible.
Full n book chapt verse text
full contains a unique identifier n is the book name,chapt verse are hopefully self explanatory, and column ‘text’ contains the Bible verse and for each translation on the text field is different all the other columns are the same. What i am trying to do is say display half a dozen translations side by side, thus making it easy to spot the different translations.
I can do some kind of a join but when i display the query i only get one table. Any pointers greatly appreciated. Thank you for your time.
i have the tables all in the same structure. I am half way through a mysql course which is teaching me about joins. I have tried some joins but each time i try and display the different bible verses i only get one translation!
hermeneutika is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3