 |
| SQL Server 2005 General discussion of SQL Server *2005* version only. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
May 12th, 2011, 10:16 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
Imar ask you to change InnerJoin for Inner Join (see the space on between the two words?)
__________________
HTH
Gonzalo
================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========
|
|
May 12th, 2011, 10:41 AM
|
|
Authorized User
|
|
Join Date: May 2011
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
joining 3 tables in a query
Do you mean I should change InnerJoin to Inner Join?
|
|
May 12th, 2011, 10:48 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
Imar ask you to do that.. an usually his English is far better than mine... :)
__________________
HTH
Gonzalo
================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========
|
|
May 12th, 2011, 11:36 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Quote:
|
Do you mean I should change InnerJoin to Inner Join?
|
Euuuhhhmmmmm
Quote:
|
Imar ask you to change InnerJoin for Inner Join
|
What else could that mean?
or this
Quote:
|
Did you try INNER JOIN versus InnerJoin?
|
InnerJoin is not a keyword in SQL. It's INNER JOIN with a space between the words.
Imar
Last edited by Imar; May 12th, 2011 at 11:39 AM..
|
|
May 12th, 2011, 11:38 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
And the tip of the day:
Quote:
|
I also didn't understand you on the post that you sent me on InnerJoin
|
If you get a reply you don't understand, don't continue posting new stuff, but post something like: I didn't understand your answer. Can you explain it in more detail?
It's hard to see whether you understand something or not over a forum post, so you should ask for clarification if you need it.
Cheers,
Imar
|
|
May 12th, 2011, 11:57 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
|
|
Lookslikeyouhavemultipleproblemshereoneofwhichisth ereisnospacebetween inner and join. Doesn't look like your aggregate SUM function is going to work either.
Try putting a space in "INNER JOIN" and remove that SUM selection and see if your query will run.
|
|
May 12th, 2011, 01:14 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
Quote:
Originally Posted by sauloftarsus
Do you mean I should change InnerJoin to Inner Join?
|
Quote:
Originally Posted by rstelma
Lookslikeyouhavemultipleproblemshereoneofwhichisth ereisnospacebetween inner and join. Doesn't look like your aggregate SUM function is going to work either.
Try putting a space in "INNER JOIN" and remove that SUM selection and see if your query will run.
|
Lol :)
In my second or third post I already mentioned that.. but like my golf teacher says, one problem at a time...
__________________
HTH
Gonzalo
================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========
|
|
May 13th, 2011, 03:07 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Quote:
|
but like my golf teacher says, one problem at a time...
|
My idea exactly. Not much point debugging a SUM when the JOINs are not OK ;-)
Imar
|
|
May 13th, 2011, 05:23 AM
|
|
Authorized User
|
|
Join Date: May 2011
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
joining 3 tables in a query
When I changed it, it worked but there is another exception, thus
StockCart.StockCartID is not valid because it is not part of an aggrege function.
|
|
May 13th, 2011, 08:58 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
Great.. Now, if you readed the thread, you need a group by to use a SUM in your query..
Get it?
__________________
HTH
Gonzalo
================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========
|
|
|
button below this post to show your appreciation!
