|
 |
asp_databases thread: a newbie question
Message #1 by "Jimmy Ho" <jimmyyl@h...> on Thu, 21 Dec 2000 14:47:00 +0800
|
|
What is the difference between
select fieldA, fieldB, fieldC from tableA LEFT JOIN tableB ON tableA.id
tableB.id
and
select fieldA, fieldB, fieldC from tableA, tableB where tableA.id *
tableB.id
By the way and good online documentation site for SQL command?
Thanx
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "Dave Sussman" <davids@i...> on Thu, 21 Dec 2000 09:34:16 -0000
|
|
At it's simplest LEFT OUTER JOIN is ANSI standard, whereas *= isn't and may
not be supported in future versions of the product (although personally I
can't see them dropping it). To quote from Inside SQL Server 7.0 (Ron
Soukup, MSPress - go buy it)
The ANSI format separates the JOIN criteria from the WHERE criteria,
whereas the old style is prone to ambiguities.
The Ron Soukup book has several pages devoted to the difference, and it's
too long to quote here. To be safe use the ansi sytax.
Dave
"Jimmy Ho" <jimmyyl@h...> wrote in message news:26831@a..._databases...
>
> What is the difference between
> select fieldA, fieldB, fieldC from tableA LEFT JOIN tableB ON tableA.id
> tableB.id
> and
> select fieldA, fieldB, fieldC from tableA, tableB where tableA.id *
> tableB.id
>
> By the way and good online documentation site for SQL command?
> Thanx
>
>
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #3 by Adil Hindistan <Adilhn@y...> on Thu, 21 Dec 2000 11:53:45 +0200
|
|
http://sqlcourse.com is OK, easpecially for newbies (like myself :)
Adil Hindistan, CE-93
www.scorion.net
ICQ:26477783
> -----Original Message-----
> From: Jimmy Ho [mailto:jimmyyl@h...]
> Sent: 21 Aralik 2000 Persembe 08:47
> To: ASP Databases
> Subject: [asp_databases] a newbie question
>
>
> What is the difference between
> select fieldA, fieldB, fieldC from tableA LEFT JOIN tableB ON
> tableA.id
> tableB.id
> and
> select fieldA, fieldB, fieldC from tableA, tableB where tableA.id *
> tableB.id
>
> By the way and good online documentation site for SQL command?
> Thanx
>
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
