• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2117
  • Last Modified:

inner join in oracle 8

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
giovamc
Asked:
giovamc
  • 2
  • 2
1 Solution
 
ubascheCommented:
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
 
maheshmandaveCommented:
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
 
ubascheCommented:

The syntax using a "(+)" in the join condition is an outer join in Oracle.
For innerjoins you have to join without "(+)".
0
 
maheshmandaveCommented:
Hi ubasche
thx for clearing my fundamentals
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now