Platform: SQL 2000 on Win2k Server
Would like to use a stored procedure or Query that will take the results of a Column from a query(Select PartName FROM tblparts WHERE WOID=20)with a matched ID from the parent query (Select WOID, WOName, PartsList= ? FROM tblWorkorders INNER JOIN …), and use the merged results as a column for another query. I believe the PartsList = thing will not work.
tblparts
ID |WOID |partname
1 |20 |RJ45mod tip
2 |20 |Cat5e Cable Per Feet
tblWorkOrders
WOID |WOName
22 |Test Work Order
Would like to have a results set that would have
WOID |WOName |PartsUsed(as a text field)
22 |Test Work Order |RJ45mod tip, Cat5e Cable Per Feet
I could do this via VBA in code but would like it for speed reasons done via a stored procedure or a query.