Toad World® Forums

Sub-query visible fields not showing in main query

Is there a limit to the number of visible subquery fields that will show in the main query? I'm using the following:

Toad Data Point 4.3.0.718 (32 bit)
Oracle Database (Ellucian Banner)

When I build:
Quey
-> Subquery1
-> -> Subquery2

I have noticed that only some of the visible fields that are in Subquery1 will show up in the main query under Diagram. What is happening? Is there a way to force them to show? See the attached images:

Donavan Kienenberger | Systems & Data Specialist
University of Alaska Fairbanks | Office of the Registrar

SELECT SubSORCMJR.SORCMJR_TERM_CODE_EFF,
       SOBCURR.SOBCURR_PROGRAM,
       SubSORCMJR.SORCMJR_MAJR_CODE,
       SubSORCMJR.STVMAJR_DESC,
       SubSORCMJR."ADM? Major",
       SubSORCMJR.SORCCON_MAJR_CODE_CONC
FROM SATURN.SOBCURR SOBCURR
     LEFT OUTER JOIN
     (SELECT SORCMJR.SORCMJR_CURR_RULE,
             SORCMJR.SORCMJR_TERM_CODE_EFF,
             SORCMJR.SORCMJR_ADM_IND AS "ADM? Major",
             SORCMJR.SORCMJR_MAJR_CODE,
             STVMAJR_MJR.STVMAJR_DESC,
             SubSORCCON.SORCCON_MAJR_CODE_CONC,
             SubSORCCON.STVMAJR_DESC,
             SubSORCCON."ADM? Concentration"
      FROM (SATURN.SORCMJR SORCMJR
            INNER JOIN SATURN.STVMAJR STVMAJR_MJR
               ON (SORCMJR.SORCMJR_MAJR_CODE = STVMAJR_MJR.STVMAJR_CODE))
           LEFT OUTER JOIN
           (SELECT SORCCON.SORCCON_CURR_RULE,
                   SORCCON.SORCCON_TERM_CODE_EFF,
                   SORCCON.SORCCON_CMJR_RULE,
                   SORCCON.SORCCON_ADM_IND AS "ADM? Concentration",
                   SORCCON.SORCCON_MAJR_CODE_CONC,
                   STVMAJR_CON.STVMAJR_DESC
            FROM SATURN.SORCCON SORCCON
                 INNER JOIN SATURN.STVMAJR STVMAJR_CON
                    ON (SORCCON.SORCCON_MAJR_CODE_CONC =
                        STVMAJR_CON.STVMAJR_CODE)
            WHERE     (SORCCON.SORCCON_ADM_IND = 'Y')
                  AND (SORCCON.SORCCON_MAJR_CODE_CONC <> 'NOCN')) SubSORCCON
              ON     (SORCMJR.SORCMJR_CURR_RULE =
                      SubSORCCON.SORCCON_CURR_RULE)
                 AND (SORCMJR.SORCMJR_TERM_CODE_EFF =
                      SubSORCCON.SORCCON_TERM_CODE_EFF)
                 AND (SORCMJR.SORCMJR_CMJR_RULE =
                      SubSORCCON.SORCCON_CMJR_RULE)) SubSORCMJR
        ON (SOBCURR.SOBCURR_CURR_RULE = SubSORCMJR.SORCMJR_CURR_RULE)
WHERE     (SOBCURR.SOBCURR_LEVL_CODE LIKE '%F')
      AND (SubSORCMJR.SORCMJR_TERM_CODE_EFF >= :TERM_CODE_EFF)

The only thing that comes to mind is that if I have already run the main query and then I go back into a subquery to add additional columns, it won't appear in the main query until I either re-run the main query or first go into the subquery and run just the subquery.