|
| |
|
|
mikeb
Posts: 53
Joined: 10/15/2003
Status: offline
 |
MS SQL Results-Joined Query Question - 6/15/2004 21:50:26
I have the following query that returns data from two tables. RequestStatus has multiple records for each item in RequestData. I need to be able to pick just the last record from RequestStatus. As this query stands, I get the record from RequestData once for each record in RequestStatus... any DB guru's can help?
SELECT crdb.RequestData.OurIssueNumber, crdb.RequestData.ProblemDescription, crdb.RequestData.ITTicketNumber, crdb.RequestData.RequestTypeSlect,
crdb.RequestData.OurPriority, crdb.RequestData.TheirPriority, crdb.RequestData.DateEntered, crdb.RequestData.ImpactStatement,
crdb.RequestData.SystemName, crdb.RequestData.WorkaroundStatement, crdb.RequestData.PlannedReleaseCycle, crdb.RequestData.LastUpdateBy,
crdb.RequestData.ErrorCodes, crdb.RequestData.TRCR, crdb.RequestStatus.ID, crdb.RequestStatus.DateOfStatus, crdb.RequestStatus.OldStatus,
crdb.RequestStatus.NewStatus, crdb.RequestStatus.StatusKey, crdb.TSMs.Fname, crdb.TSMs.Lname
FROM crdb.RequestStatus INNER JOIN
crdb.RequestData ON crdb.RequestStatus.StatusKey = crdb.RequestData.OurIssueNumber INNER JOIN
crdb.TSMs ON crdb.RequestData.LastUpdateBy = crdb.TSMs.CUID
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 