MySQL Forums
Forum List  »  General

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..

Options: ReplyQuote


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.