Urgent Oracle SQL Question (INNER JOIN)

[TheFaQQer]

Actually, working on Plan B

Sounds like you need a better local oppo, then, if you need to tell him how to select from two tables!

[Platypus]

Sounds like you need a better local oppo, then, if you need to tell him how to select from two tables!

Not my oppo, customer's oppo. Plan B can't afford its own oppo yet

[BrilloPad]

that would work fine too, technically no reason not to
Personally I'd say that good practice dictates otherwise though

Every person I have met who has used inner join has been a complete numpty. Those who use "=" are far better.

Maybe it is just me?

[TheFaQQer]

Every person I have met who has used inner join has been a complete numpty. Those who use "=" are far better.

Maybe it is just me?

No, it's not just you.

I've never written an inner join using the ANSI syntax.

Some clients will demand that you use it, but I would still only use the ANSI syntax for outer joins rather than an inner join.

[Spacecadet]

Every person I have met who has used inner join has been a complete numpty. Those who use "=" are far better.

Maybe it is just me?

I used to use "=" then switched

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

[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

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

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]

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]

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.