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

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: 63911
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":

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

Current Time: Sat Oct 22 15:23:11 CDT 2016

Total time taken to generate the page: 0.08287 seconds