Thread: Combining queries
08-05-12, 12:30 #1Registered User
- Join Date
- Jul 2012
Unanswered: Combining queries
I am trying to combine two different select statements but I have not been able to figure out the proper formation.... They are:
SELECT Student_t.LastName, Student_t.Firstname, ENROLLMENT_STATUS_T.Description
RIGHT JOIN ENROLLMENT_STATUS_T
ON Student_t.StudentID = Enrollment_Status_t.StudentID
select trunc(months_between(sysdate,EnrollmentDate)/12) "Years Enrolled"
Thanks again for the help!
08-05-12, 12:42 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>I am trying to combine two different select statements
Have you tried using Super Glue to get them to stick together?
We don't have your tables or data.
We don't know what result set you expect or desire.
How will you, I or anyone recognize when correct SQL is posted here?You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.