SELECT     d.dhatuid, d.dhatu, d.meaning, d.gana, d.pada, l.lakara,  dr.purusha, dr.vacana, dr.roopa
FROM         dhatupatha d, dhaturoopa dr, lakara l, purusha p,  vacana v
                      where dr.dhatuid = d.dhatuid  and dr.lakara = l.lakaraID AND p.purushaid=dr.purushaid and v.vacanaid =dr.vacanaid

ORDER BY d.dhatu,l.kramaa, dr.purushaid, dr.vacanaid


SELECT     d.dhatuid, d.dhatu, d.meaning, d.gana, d.pada, l.lakara,  dr.purusha, dr.vacana, dr.roopa
FROM         dhatupatha d, dhaturoopa dr, lakara l, purusha p,  vacana v
                      where dr.dhatuid = d.dhatuid  and dr.lakara = l.lakaraID AND p.purushaid=dr.purushaid and v.vacanaid =dr.vacanaid

ORDER BY d.dhatu,l.kramaa, dr.purushaid, dr.vacanaid



SELECT     d.dhatuid, d.dhatu, d.gana, d.pada, d.meaning, dr.roopa
FROM        dhaturoopa AS dr, dhatupatha as d
where      dr.dhatuid = d.dhatuid
ORDER BY d.dhatu

dhatuid not found in dhatupatha
335
6
29
321
187
359
47
311
205
168
194
309