1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Noob Forum

Discussion in 'SQL Exams' started by chicola, Sep 28, 2015.

  1. chicola

    chicola Bit Poster

    20
    0
    2
    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.
     
  2. jk2447

    jk2447 Petabyte Poster Moderator

    5,483
    354
    249
    Post on here mate it costs nothing and there are no silly questions. We don't bite
     
    Certifications: BSc (Hons), HND IT, HND Computing, ITIL-F, MBCS CITP, MCP (270,290,291,293,294,298,299,410,411,412) MCTS (401,620,624,652) MCSA:Security, MCSE: Security, Security+, CPTS, VCP4, CCA (XenApp6.5), MCSA 2012, VCP5, VCP6-NV
  3. SimonD

    SimonD Terabyte Poster Moderator

    3,463
    397
    199
    Well most of us, Jim has had several warnings and we do muzzle him sometimes ;)
     
    Certifications: CNA | CNE | CCNA | MCP | MCP+I | MCSE NT4 | MCSA 2003 | Security+ | MCSA:S 2003 | MCSE:S 2003 | MCTS:SCCM 2007 | MCTS:Win 7 | MCITP:EDA7 | MCITP:SA | MCITP:EA | MCTS:Hyper-V | VCP 4 | ITIL v3 Foundation | VCP 5 DCV | VCP 5 Cloud | VCP6 NV | VCP6 DCV | VCAP 5.5 DCA
    WIP: VCP6-CMA, VCAP-DCD and Linux + (and possibly VCIX-NV).
  4. jk2447

    jk2447 Petabyte Poster Moderator

    5,483
    354
    249
    What can I say, I'm a giver :)
     
    Certifications: BSc (Hons), HND IT, HND Computing, ITIL-F, MBCS CITP, MCP (270,290,291,293,294,298,299,410,411,412) MCTS (401,620,624,652) MCSA:Security, MCSE: Security, Security+, CPTS, VCP4, CCA (XenApp6.5), MCSA 2012, VCP5, VCP6-NV
  5. chicola

    chicola Bit Poster

    20
    0
    2
    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.
     
  6. dmarsh

    dmarsh Terabyte Poster

    3,782
    302
    184
    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
     
    Certifications: CITP, BSc, HND, SCJP, SCJD, SCWCD, SCBCD, SCEA, N+, Sec+, Proj+, Server+, Linux+, MCTS, MCPD, MCSA, MCITP, CCDH
    jk2447 likes this.
  7. chicola

    chicola Bit Poster

    20
    0
    2
    Many thanks, that worked.
     
  8. jk2447

    jk2447 Petabyte Poster Moderator

    5,483
    354
    249
    There you go. So in answer to "Is there a good forum online that is well suited to complete noobs in SQL? " I recommend one called Certforums.co.uk :cjeremy635::dance3::perfect10:
     
    Certifications: BSc (Hons), HND IT, HND Computing, ITIL-F, MBCS CITP, MCP (270,290,291,293,294,298,299,410,411,412) MCTS (401,620,624,652) MCSA:Security, MCSE: Security, Security+, CPTS, VCP4, CCA (XenApp6.5), MCSA 2012, VCP5, VCP6-NV

Share This Page

Loading...