- Joined
- Oct 28, 2006
- Messages
- 36,581
- Likes received
- 3,172
- Thanks received
- 1,186
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!
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!

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?
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

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