Urgent Oracle SQL Question (INNER JOIN)

[Spacecadet]

the (+) notation is still messy

A well formatted select statement using the "inner join" "left out join" notation is much easier to read and to achieve consistant results with.

table_a a
   inner join table_b b
      on a.col1 = b.col1
     and a.col2 = b.col2
   inner join table_c c
      on a.col1 = c.col1
     and a.col2 = c.col2
    left outer join table_d d
      on d.col1 = a.col3
    left outer join table_e e
      on b.col3 = e.col1

[oracleslave]

After all, there is no other database but Oracle.

[BrilloPad]

I'll bear that in mind for when Oracle migrate the eBusiness Suite away from the Oracle database

After all, there is no other database but Oracle.

We use sybase - I miss oracle so much.

The thing I have trouble with on outer joins is which side to add the "*" - I always get it wrong first time!

[Bumfluff]

We use sybase - I miss oracle so much.

The thing I have trouble with on outer joins is which side to add the "*" - I always get it wrong first time!

I miss Oracle as well, current client is Sybase hadnt used it for years always had been Oracle, all I can is Sybase is such a pile of sh8t compared to Oracle. One of the DBs I connect to is Sybase Adaptive Server IQ and I cant find any sql tool, apps like Toad etc that will run correctly with it, I have to use some sh*tty IQ sql interface.

Sybase poo, Oracle great

[Spacecadet]

I miss Oracle as well, current client is Sybase hadnt used it for years always had been Oracle, all I can is Sybase is such a pile of sh8t compared to Oracle. One of the DBs I connect to is Sybase Adaptive Server IQ and I cant find any sql tool, apps like Toad etc that will run correctly with it, I have to use some sh*tty IQ sql interface.

Sybase poo, Oracle great

I did have a tool for connecting to any of the major database products.
I'll see if i can find it!

edit:
Got it: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp

[TheFaQQer]

Who was it that didn't get the gig because they didn't use the ANSI standard in one of the technical tests?

Someone on here did it (but eventually got the gig anyway).

[MrRobin]

Who was it that didn't get the gig because they didn't use the ANSI standard in one of the technical tests?

Someone on here did it (but eventually got the gig anyway).

I remember that post. Didn't know they got the gig eventually. Good that common sense provailed.

[TheFaQQer]

It was MobileCheese - found it here.

[MrRobin]

It was MobileCheese - found it here.

Ah yes. MobileCheese has been inactive for almost 2 months. Must be all that ANSI standard training he's doing

[expat]

Once you start writing more complex queries you'll understand the benefits

Once I started writing more complex queries, I began to understand the benefits of not writing more complex queries.