Hi
I've got a fairly straight forward problem. Given the statemtent and results below:
SELECT DISTINCT dbo.tblTaskStock.StockID, dbo.tblTaskNames.TaskName
FROM dbo.tblTaskNames INNER JOIN
dbo.tblTasks ON dbo.tblTaskNames.TaskID = dbo.tblTasks.TaskID INNER JOIN
dbo.tblTaskStock ON dbo.tblTasks.ID = dbo.tblTaskStock.TaskID
3166 Delivery
3166 Hotstage
3167 Delivery
3167 Hotstage
What im looking for are these results:
3166 Delivery,Hotstage
3167 Delivery,Hotstage
Not sure how this is done.
Thanks
I've got a fairly straight forward problem. Given the statemtent and results below:
SELECT DISTINCT dbo.tblTaskStock.StockID, dbo.tblTaskNames.TaskName
FROM dbo.tblTaskNames INNER JOIN
dbo.tblTasks ON dbo.tblTaskNames.TaskID = dbo.tblTasks.TaskID INNER JOIN
dbo.tblTaskStock ON dbo.tblTasks.ID = dbo.tblTaskStock.TaskID
3166 Delivery
3166 Hotstage
3167 Delivery
3167 Hotstage
What im looking for are these results:
3166 Delivery,Hotstage
3167 Delivery,Hotstage
Not sure how this is done.
Thanks