Home » SQL & PL/SQL » SQL & PL/SQL » Inner Join example
Inner Join example [message #242688] Mon, 04 June 2007 12:27 Go to next message
santhoshgarlapad
Messages: 10
Registered: November 2005
Junior Member
Hi Guys,

Can you please give me an example of Inner join and how innerjoin is differ from Equi Join?

Thanks
Santhosh
Re: Inner Join example [message #242692 is a reply to message #242688] Mon, 04 June 2007 12:52 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Replace = by > in an equi-join and you have an inner join that is not an equi-join.

If course documentation can give you more:
"SQL Reference", Chapter 9 "SQL Queries and Subqueries", section "Joins":
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#i2054012


Regards
Michel
Previous Topic: IF or CASE
Next Topic: WHY IT'S NOT
Goto Forum:
  


Current Time: Sat Dec 10 07:04:59 CST 2016

Total time taken to generate the page: 0.09335 seconds