Natural Join
Posted by:
Yi Ling
Date: August 26, 2004 10:28PM
from MySQL website, i cant find any about natural join..
i went to google and search for Natural Join... this works like this -->
without using Natural Join..
select * from parent, child where child.parentID = parent.parentID
using Natural Join..
select * from parent NATURAL JOIN child
this can save a lots of work when selecting query from multiple table~~
so, is MySQL database supports NATURAL JOIN ???
Thanks for help..
Subject
Written By
Posted
Natural Join
August 26, 2004 10:28PM
September 28, 2004 09:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.