"Don't use joins ... Oracle and SQL Server have fundamentally different
approaches to the concept ... You can end up with unexpected result sets
... You should understand the basic types of join clauses ... Equi-joins
are formed by retrieving all the data from two separate sources and
combining it into one, large table... Inner joins are joined on the
inner columns of two tables. Outer joins are joined on the outer
columns of two tables. Left joins are joined on the left columns of two
tables. Right joins are joined on the right columns of two tables."
>As a second joke of the week...Here is a decent attempt at
Actually, it is a new week now, so you get first joke of the
week.
>incorporation of database design as a part of the gaming industry...A
>sign of our time...I do not know if I should laugh or cry...
>
>http://www.youtube.com/watch?v=LpDyUAHuSLI&feature=related
I was going to advise "cry", but now, I am not sure either.
Pretty graphics and music, but not terribly informative.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
I didn't see the first joke so stop me if you've heard this one.
An SQL query goes into a bar and sees two tables in the corner. So it
goes over and says, "Mind if I join you?"
--
Roy
The response was, "Well, if I were going to Redbud, I certainly wouldn't
start from here!"
(from the movie "Funny Farm")