0 votes 0 votes how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause? Databases natural-join databases sql + – aditi19 asked May 8, 2019 aditi19 775 views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply srestha commented May 8, 2019 reply Follow Share Plz give some direct question regarding this 0 votes 0 votes aditi19 commented May 9, 2019 reply Follow Share Suppliers(sid, sname, saddress) Parts(pid, pname, color) Catalog(sid, pid, cost) Find the names of suppliers and the name of parts supplied by them how to write SQL query using natural join clause on three tables 0 votes 0 votes srestha commented May 9, 2019 reply Follow Share $\pi _{sname,pname}\left ( \sigma _{supplier.sid=catalog.sid\wedge parts.pid=catalog.pid}\left ( Suppliers\bowtie Parts\bowtie Catalog \right ) \right )$ $OR$ Select sname,pname from Suppliers, Parts,Catalog where Supplier.sid=Catalog.sid and Parts.pid=Catalog.pid 0 votes 0 votes aditi19 commented May 9, 2019 reply Follow Share @srestha I asked to use the clause NATURAL JOIN in the query not equi join or conditional joins 0 votes 0 votes srestha commented May 9, 2019 reply Follow Share Is it not sign of natural join? chk this https://www.tutorialspoint.com/dbms/database_joins.htm 0 votes 0 votes aditi19 commented May 9, 2019 reply Follow Share this is conditional join 0 votes 0 votes srestha commented May 9, 2019 reply Follow Share ok, so remove that condition, then it will be naturaljoin $\pi _{sname,pname}\left ( Suppliers\bowtie Parts\bowtie Catalog \right ) $ natural-join 0 votes 0 votes aditi19 commented May 9, 2019 reply Follow Share correct so now my question is how will u implement this in SQL w/o using any equality condition 0 votes 0 votes srestha commented May 9, 2019 reply Follow Share Select sname,pname from Suppliers Natural-join Parts Natural-join Catalog 0 votes 0 votes srestha commented May 9, 2019 reply Follow Share U can see more on natural join in :https://stackoverflow.com/questions/5147453/how-to-do-3-table-natural-join 0 votes 0 votes Please log in or register to add a comment.