query syntax problem

  • I have a query that is working successfully, just wanting to add a third table to it and trying several things but not getting the results needed. Here is the starting query and a description for the third table. Any ideas? Thanks!!

    SELECT k.AttributeKeyID, a.AttributeKeyID, k.AttributeKeyDsc, a.WorkItemID, a.KeyValueTxt

    FROM WorkItemAttributeKey AS k INNER JOIN

    WorkItemAttribute AS a ON k.AttributeKeyID = a.AttributeKeyID

    WHERE (a.WorkItemID = 107893)

    SELECT c.WorkItemID, c.CommentTxt

    FROM WorkItemComment As c

    WHERE (c.WorkItemID = 107893)

  • briancampbellmcad (6/28/2013)


    I have a query that is working successfully, just wanting to add a third table to it and trying several things but not getting the results needed. Here is the starting query and a description for the third table. Any ideas? Thanks!!

    SELECT k.AttributeKeyID, a.AttributeKeyID, k.AttributeKeyDsc, a.WorkItemID, a.KeyValueTxt

    FROM WorkItemAttributeKey AS k INNER JOIN

    WorkItemAttribute AS a ON k.AttributeKeyID = a.AttributeKeyID

    WHERE (a.WorkItemID = 107893)

    SELECT c.WorkItemID, c.CommentTxt

    FROM WorkItemComment As c

    WHERE (c.WorkItemID = 107893)

    Like this?

    SELECT k.AttributeKeyID, a.AttributeKeyID, k.AttributeKeyDsc, a.WorkItemID, a.KeyValueTxt, c.WorkItemID, c.CommentTxt

    FROM WorkItemAttributeKey AS k

    INNER JOIN WorkItemAttribute AS a ON k.AttributeKeyID = a.AttributeKeyID

    INNER JOIN WorkItemComment As c on c.WorkItemID = a.WorkItemID

    WHERE (a.WorkItemID = 107893)

    If that isn't enough to get you there we will need a few things:

    1. Sample DDL in the form of CREATE TABLE statements

    2. Sample data in the form of INSERT INTO statements

    3. Expected results based on the sample data

    Please take a few minutes and read the first article in my signature for best practices when posting questions.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Thanks! this worked

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply