Hello
I need to get data from 4 Oracle tables and combine them into a
temporary table in my application. I get data using a pass-through
query dynamically created in code:
mySQL = "SELECT SID_SCREENING_TASKS_QUESTIONS.TASK_ID,
mySQL = mySQL & "SID_SCREENING_TASKS_QUESTIONS.ID,
mySQL = mySQL & "SID_SCREENING_QUESTIONS.TITLE, "
mySQL = mySQL & "SID_SCREENING_QUESTION_STUDENT.Points "
mySQL = mySQL & "from SID_SCREENING_TASKS_QUESTIONS,
SID_SCREENING_QUESTIONS, "
mySQL = mySQL & "SID_SCREENING_QUESTION_STUDENT "
mySQL = mySQL & "WHERE
SID_SCREENING_TASKS_QUESTIONS.ID=SID_SCREENING_QUE STIONS.ID and "
mySQL = mySQL & "SID_SCREENING_TASKS_QUESTIONS.ID=SID_SCREENING_QU ESTION_STUDENT.ID(+)
and SID_SCREENING_QUESTIONS.DELETED IS NULL AND "
mySQL = mySQL & "(SID_SCREENING_QUESTION_STUDENT.STUDENT_CODE IS NULL
OR "
mySQL = mySQL & "SID_SCREENING_QUESTION_STUDENT.STUDENT_CODE=" &
Me![txtStuCode] & ");"
If IsLive = True Then
Set myQuery = "qryScreening_live"
Else
Set myQuery = "qryScreening_test"
End If
myQuery.SQL = mySQL
Set myRSet = myQuery.OpenRecordset
When I have this recordset, I'll copy the data into a predefined table
looping through the recordset.
A question: can I create the above query so that it creates a table
with the data returned?
Thank you.
Galina
