Hoping to find some help.
I have a table of records that assigns a record of work to each individual Shape in a street centerline table where there is a common ID match (Made using SQL, below). There are multiple shapes for each record of work which means the SQL pulls in over 1000 records for only a 100 different record of work performed.
I want to condense that table so there is only one multipart feature for each record, but also maintain all the information from the record. If I use tools such as Dissolve, join features etc, all attribute information is lost.
SELECT
Table A. WorkID
Table B. EID
Table C. Shape
FROM
Table A
inner join
Table B
on Table A.[WORKID] = Table B.[WORKID] and TABLE A.[DESCRIPTION] like 'Quote'
inner JOIN
Table C
ON
Table C.[ID] = Table B.[EID]
order by WE.[WORKORDERID] DESC
Is there a way in SQL to join all the shape fields together, or what geoprocessing steps can I take to get to my end result?