Post reply

forming a SQL statement for this scenario

  • March 6, 2008 at 8:17 am

    #187555

    I am having startup problem trying to form this query. Any help would be

    appreciated.

    I have a 3 tables :

    1. tblCaseInfo with CaseID, ResolutionID

    2. tblSessions with CaseID, Location

    3. tlkResolution with ResolutionID

    I need to get all resolved cases for a particular LOCATION.

    Thanks

    Arun

  • March 6, 2008 at 8:49 am

    #786050

    arun.samuel (3/6/2008)

    I am having startup problem trying to form this query. Any help would be

    appreciated.

    I have a 3 tables :

    1. tblCaseInfo with CaseID, ResolutionID

    2. tblSessions with CaseID, Location

    3. tlkResolution with ResolutionID

    I need to get all resolved cases for a particular LOCATION.

    Thanks

    Arun

    Select from

    tblCaseInfo C

    join tblSessions S on S.CaseID = C.CaseID

    join tblResolution R on C.ResolutionId = R.ResolutionID

    where

  • March 6, 2008 at 9:09 am

    #786084

    That did it.

    You made it look so easy.

    Thanks,

    Arun

  • March 6, 2008 at 10:05 am

    #786154

    Continuing with the above query, trying to do the following, but gives an error saying multi-part identifier S.SessionsLocName could not be bound

    SELECT COUNT(C.CaseID) AS CaseCount

    FROM tblCaseInfo C

    JOIN tblSessions S on S.CaseID = C.CaseID

    JOIN tblResolution R on C.ResolutionID = R.ResolutionID

    WHERE (S.SessionLocName = 'CMC')

    Thanks,

    Arun

  • March 6, 2008 at 10:07 am

    #786155

    There was a typo in the S.SessionsLocName, it should read S.SessionLocName

    Thanks,

    Arun

Viewing 5 posts - 1 through 4 (of 4 total)

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