SQL Noob Forum

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi,

Is there a good forum online that is well suited to complete noobs in SQL? I need to ask some laughably basic questions as I am very much a beginner.

Can someone recommend one to me as I have searched, but am scared to post on the forums I have found as they look more suited to professionals.

Thanks.

 

Well most of us, Jim has had several warnings and we do muzzle him sometimes ;)

 

Okay I have the query below and when I remove the comments from "AS TotalItemsOver$1000" I get the error message "The multi-part identifier SalesLT.SalesOrderDetail.ProductID could not be bound". Can you explain why?

SELECT SUM(OrderQty)FROM SalesLT.SalesOrderDetail

--AS TotalItemsOver$1000


INNERJOIN SalesLT.Product

ON SalesLT.SalesOrderDetail.ProductID = SalesLT.Product.ProductID

WHERE SalesLT.Product.ListPrice > 1000

Thanks.

 

http://www.w3schools.com/sql/sql_alias.asp

Looks like the alias is in the wrong place ?

Try :-

SELECT SUM(OrderQty) AS TotalOver$1000
FROM SalesLT.SalesOrderDetail AS o
INNERJOIN SalesLT.Product AS p
ON o.ProductID = p.ProductID
WHERE p.ListPrice > 1000

 

Many thanks, that worked.