Results 1 to 2 of 2

Thread: joins

  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: joins

    hi,
    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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 results
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •