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.