Need some direction on what to even search on to accomplish this.
I have a table with a PK - Product_ID and a field mfg_issues
One Product_ID could have up to 4 issues, so there are 4 lines in this particular query for that one Product_ID. If I add in PO_qty from another table I am overstating my qty by the number of extra rows I will have in my query.
I would like to create a query with 4 columns named - Issue1, Issue2,Issue3, Issue4 and pull each of these issues into it's own column.
Is there a name for what I'm trying to do?
Goal is to have only 1 line with all the other attributes for each Product_ID in my query.
Thanks