11-10-11, 23:27 #1Registered User
- Join Date
- Nov 2011
I have two table lets say students table 'Student' there Sibling table 'Sibling' and there othere education Details table 'Education'
now i need to retrieve student table information based on student id + the no of records are there in sibling and Education table for the given student_id
Hers is example
The output should be like
stud_id stud_name stud_age siblingcount application count
101 xxxx xxx 2 5
102 yyyy xxx 5 5
I know this can be achived by using subqueris but i need to perform this more efficient way(ie performance wise), so hoping to get solution in joins other other efficent way
Thanks in advance
11-10-11, 23:55 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>I know this can be achived by using subqueris
so post this solution & we will see about improving it.
post CREATE TABLE statements
post INSERT for test data that matches you expected/desired resultsYou 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.