SQL Joins

Question

There are many forests in worldeach forest has many treeseach tree has multiple leaves. Draw database schema for the above statement. Select all leaves for forest id=10. Use Only JOINS. Please write the query for this. Regards Zuber Kazi

Zuber Kazi · Answer

thanks Murali its working

Muralidharan Deenathayalan · Answer

select f.forestnamet.treenamel.leafname from forests f inner join trees t on f.forestid = t.forestid inner join leafs l on t.treeid = l.treeid where f.forestid = 10 Hope this helps.