?
Solved

INNER JOIN in oracle 8i

Posted on 2007-11-16
4
Medium Priority
?
4,937 Views
Last Modified: 2013-12-19
SELECT * FROM
TABLE1 a
INNER JOIN TABLE2 b ON (a.KEY_ID=b.KEY_ID)

doesnt this work on 8i???

what could be easy solution?..i know the option of writing a,b where a.key_id=b.key_id..



0
Comment
Question by:koolsyed
[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
4 Comments
 
LVL 18

Expert Comment

by:Jinesh Kamdar
ID: 20299611
Of course it does. What error do u get ?

select * from dual a inner join dual b on (a.dummy = b.dummy)

DUMMY DUMMY_1
X            X
0
 
LVL 35

Accepted Solution

by:
johnsone earned 150 total points
ID: 20299710
If you database version is really 8i, then Oracle does not support the ANSI join syntax until Oracle 9.

In Oracle 8, you get:

SQL> select * from dual a inner join dual b on (a.dummy = b.dummy);
select * from dual a inner join dual b on (a.dummy = b.dummy)
                     *
ERROR at line 1:
ORA-00933: SQL command not properly ended

In Oracle 9, you get:

SQL> select * from dual a inner join dual b on (a.dummy = b.dummy);

D D
- -
X X

0
 

Author Comment

by:koolsyed
ID: 20299738
This is what i am trying..
SELECT mp.a,mp.b        
  FROM M_V_S mvs , M_P mp
  INNER JOIN M_P mp ON (mvs.key_id = mp.key_id)
  ORDER BY a,b;

it says...expecting equals near INNER....
0
 
LVL 18

Expert Comment

by:Jinesh Kamdar
ID: 20299765
Oops, i didnt notice that the question was asked specifically for 8i and just went along with the zones that said Oracle 8.x / Oracle 9.x. No personal hands-on on 8i, but if John says so after trying it, then it would have to be true.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

719 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