Ajeet Mishra
What is a NATURAL JOIN in SQL?
By Ajeet Mishra in SQL Server on Sep 08 2015
  • Munesh Sharma
    May, 2016 31

    http://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljnaturaljoin.html

    • 0
  • Ajeet Mishra
    Sep, 2015 8

    It offers a further specialization of equi-joins. The join predicate arises implicitly by comparing all columns in both tables that have the same column-name in the joined tables. The resulting joined table contains only one column for each pair of equally-named columns. Example - SELECT * FROM Vendor NATURAL JOIN advance

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS