?
Solved

inner join in oracle 8

Posted on 2003-10-27
6
Medium Priority
?
2,094 Views
Last Modified: 2008-02-01
Hello I am new wroking in Oracle, so I want to know if the inner join clause work in Oracle 8.
Thanks a lot

Giova
0
Comment
Question by:giovamc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
ubasche earned 500 total points
ID: 9632273
You can use the "inner join" keyword in Oracle from Version 9
onwards. In previous versions you need to use the old Oracle syntax.


New syntax (Oracle9):

SELECT * FROM T1 INNER JOIN T2 ON T1.C1 = T2.C3


Old syntax (Oracle8):
 
SELECT * FROM T1, T2 WHERE T1.C1 = T2.C3

0
 

Expert Comment

by:maheshmandave
ID: 9648728
You can use
select * from T1,T2
where T1.C1(+)=T2.C3

where T1 and T2 are table names and C1 and C3 are columns

Hope this is OK with you
0
 
LVL 3

Expert Comment

by:ubasche
ID: 9649506

The syntax using a "(+)" in the join condition is an outer join in Oracle.
For innerjoins you have to join without "(+)".
0
 

Expert Comment

by:maheshmandave
ID: 9655186
Hi ubasche
thx for clearing my fundamentals
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question