Query For FSG Row Sets
I wrote this query to return the details of a row set. The first part of the query works great to get the account assignments and I added the union to get the headers. On some row sets it works but on most it returns at least two rows for every row in the row set. I would also like to add the rows with calculations. Any suggestions?
SELECT RRA.AXIS_SET_ID,RA.NAME,RRA.AXIS_SEQ,RRA.DESCRIPTION, RRA.LAST_UPDATED_BY,
RRC.SIGN,
rra.display_flag,
RRC.SEGMENT1_LOW||'-'||RRC.SEGMENT2_LOW||'-'||RRC.SEGMENT3_LOW||'-'||RRC.SEGMENT4_LOW||'-'||RRC.SEGMENT5_LOW||'-'||RRC.SEGMENT6_LOW||'-'||RRC.SEGMENT7_LOW||'-'||RRC.SEGMENT8_LOW "LOW",