which gives me one row and only the first outcome of three. How can I show the others in the same row? Will I have to create temporary tables and how is that done?
SELECT caseSummaries.caseTitle, caseSummaries.caseSynopsis, RESULTS.resultText FROM JNCT_RESULT_CASESUMMARY JOIN caseSummaries ON JNCT_RESULT_CASESUMMARY.caseSummary_FK = caseSummaries.caseID JOIN RESULTS ON JNCT_RESULT_CASESUMMARY.result_FK = RESULTS.result_ID GROUP BY caseSummaries.caseID;
From novice to tech pro — start learning today.