[thelist] new & improved SQL join syntax?

Randal Rust randalrust at gmail.com
Fri Jan 19 08:59:32 CST 2007


On 1/19/07, Sarah Adams <mr.sanders at geekjock.ca> wrote:

> I regularly read Rudy Limeback's "Ask the Expert" column

<snip />

> "Please always try to write your joins using JOIN syntax, not the older
> style which lists tables using commas."

It's probably been about three years ago that I started writing my
joins this way, and Rudy is the one who clued me in to it.

In fact, I highly recommend a book that Rudy helped co-author,
"Practical Web Database Design."

http://www.amazon.com/Practical-Database-Design-Chris-Auld/dp/1590591941/sr=8-1/qid=1169218736/ref=sr_1_1/105-0046404-6243656?ie=UTF8&s=books

-- 
Randal Rust
R.Squared Communications
www.r2communications.com



More information about the thelist mailing list