Store procedure for retrieving data from multiple tables?

Question

I have some five tables which look like this

BugHistory             
--------------------   
BugHistoryID
BugId
EmployeeId                  

Bugs
--------------------
BugID
Description
ProjectID
PriorityID

Employee                    
-------------------      
EmployeeId
EmployeeName   

Projects                
-------------------     
ProjectID
ProjectName    

Priority
-------------------
PriorityID
PriorityName

I want to retrieve data from all of the tables, making BugHistory the main table.

I need [Description],[ProjectName],[PriorityName] from all the remaining four tables where EmployeeID is the key.

The data should be retrieved based on EmployeeID from BugHistory table; I will be getting the EmployeeID based on login. Can any one help me in writing this query?

What does your query look like? What have you tried?

LittleBobbyTables - Au Revoir
– LittleBobbyTables - Au Revoir

2012-07-23 13:58:08 +00:00
Commented Jul 23, 2012 at 13:58 — LittleBobbyTables - Au Revoir
– LittleBobbyTables - Au Revoir, Commented Jul 23, 2012 at 13:58

Taryn · Accepted Answer · 2012-07-23 13:58:39Z

4

This should get you what you need.

SELECT b.Description
    , pj.ProjectName
    , pr.PriorityName
FROM BugHistory bh
INNER JOIN Employee e
     ON bh.EmployeeId = e.EmployeeId
INNER JOIN Bugs b
     ON bh.BugId = b.BugId
INNER JOIN Project pj
    ON b.ProjectId = pj.ProjectId
INNER JOIN Priority pr
    ON b.PriorityId = pr.PriorityId

answered Jul 23, 2012 at 13:58

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Store procedure for retrieving data from multiple tables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related