How to write query in my sql to display sura,aya , word and phonemes positions for all quran soras in this database?

46 0

Get full Expert solution in seconds

$1.97 ONLY

EXPERT ANSWER

select
   sura,
   aya,
   word,
   phoneme_position 
from
   quran_text qt 
   join
      quran_text_has_words qthw 
      on qt.index = qthw.id_quran_text 
   join
      words wd 
      on wd.index = qthw.id_words 
   join
      word_has_phonemes whp 
      on whp.id_words = wd.index;

Above shown is the query to display sura, aya, word and phonemes positions for all quran soras in this database.