Re: Newbie - SQL

What you did wrong was try to take your knowledge, likely based on a Microsoft product, and assume you could blindly apply it to Oracle: You can not. The Microsoft syntax has been added with version 9i but is not present in 8i or before.

You will also likely find that you will make huge messes if you make assumptions based on how other products do things and apply them to Oracle. Oracle's transaction, locking, and multiversioning are completely different and greatly affect what you write, when you write it, and how things work. I strongly urge you to get a good book on Oracle and not rely on your previous experience except as a starting point.

Daniel Morgan

Addison Schildt wrote:

> Learning with Oracle 8i (UNIX). The SQL below gives
>
> ORA-00933: SQL command not properly ended
>
> SELECT Table1.*, Table2.*
> FROM Table1 INNER JOIN Table2 ON Table1.ID = TABLE2.ID;
>
> What have I done wrong? Thanks in advance.
Received on Mon Apr 01 2002 - 15:20:35 CST