General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL Merge Results of column in Query fld
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.