Reply to: Urgent Oracle SQL Question (INNER JOIN)

[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.

[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

[TheFaQQer]

It was MobileCheese - found it here.

[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]

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).

[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

[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

[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!

[oracleslave]

After all, there is no other database but Oracle.

[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

[TheFaQQer]

Yeah in Oracle you can use this, but if you get into this habbit and then have to start using other databases, this syntax doesn't work.

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.

[MrRobin]

As opposed to adding (+)

Yeah in Oracle you can use this, but if you get into this habbit and then have to start using other databases, this syntax doesn't work.

[TheFaQQer]

What he said.

And if you're using a inner join and then want to switch to an outer join, you only have to change a couple of words.

As opposed to adding (+)

[MrRobin]

I used to use "=" then switched

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

What he said.

And if you're using a inner join and then want to switch to an outer join, you only have to change a couple of words.

[TheFaQQer]

I used to use "=" then switched

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

The only benefit I can see is that it helps separate the join condition from the data selection conditions.

I have enough trouble with

SELECT *
FROM emp
WHERE ename = 'KING'

to be honest - I'll leave such complex queries to others