How to get data from two different tables using stored procedures?

Question

I am new to functions so am having a bit starting trouble here

I have two tables like this

Bugs

BugID | Title | ProjectName | CreatedBy

BugHistory

BughistoryID | BugID | Assignedto | ToStatus | FromStatus

EmployeeTable

EmployeeID | EmployeeName |

[AssignedTo] column from BugHistory is a foreign key for [EmployeeId] in EmployeeTable.

I want a select statement where I have to show the bugs table in gridview with [AssignedTo] and [Tostatus] columns from BugHistory table. How can I use functions for this both procedure s any ideas please?

In Assigned to column I want the name of the employee - how can I map this?

Taryn · Accepted Answer · 2012-07-30 13:12:20Z

2

It sounds like you want this:

SELECT b.BugId
    , b.Title
    , b.ProjectName
    , b.CreatedBy
    , e.EmployeeName As AssignedTo
    , bh.ToStatus
FROM Bugs b
INNER JOIN BugHistory bh
    ON b.bugid = bh.bugid
INNER JOIN Employee e
    ON bh.AssignedTo = e.EmployeeId

answered Jul 30, 2012 at 13:12

Taryn

249k57 gold badges374 silver badges409 bronze badges

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

2 Comments

SoftwareNerd Over a year ago

@blufeet CreatedBy is also an foreign key to EmployeeID

Taryn Over a year ago

@anilkumar what do you mean no luck? Can you create a SQL Fiddle with some sample data?

Collectives™ on Stack Overflow

How to get data from two different tables using stored procedures?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related