Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexanderDelarge
Starting Member
3 Posts |
 Posted - 2011-07-12 : 11:27:07
|
| I have some tables I'm working with using an MS Access 2007 linked ODBC connection to a progress database. Essentially the main table has multiple records that are identical except for a few fields. What I would like to do is join the table to itself resulting in one record to replace (lets say 5) where new columns are created to hold each of the new quantity, line item and price that corresponds to the unique key of that record. I have seen the function Concatenate or Group_Concat do something similar to what I want but all the results are in one field...and I couldn't really get it to work anyway.These are most of the fields in the resultsQuoteDtl.QuoteNum (Group By)QuoteDtl.QuoteLineQuoteDtl.PartNumQuoteDtl.LineDescQuoteDtl.OrderQtyQuoteDtl.PricingQtyQuoteDtl.ProdCodeQuoteDtl.SellingExpectedQty |
|
|
|
|
|
Self-Join concatenate ms access