Results 1 to 8 of 8

Thread: [RESOLVED] a simple query problem regarding joins

Threaded View

  1. Dec 5th, 2007, 01:12 AM #1
    raghunadhs
    raghunadhs is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2007
    Posts
    167

    Resolved [RESOLVED] a simple query problem regarding joins

    Hi All,
    i am practising Sql Server 2000. i try to solve a query but failed. can u help me? the problem is ......I have a table called "student". my table is like this...
    student_no, student_name,student_country are my three fields.

    Student_no , Student_Name , Student_Country
    1000 Williams China
    2000 Stuvart U.S
    2500 Willams China
    3000 Stuvart Malesia
    2200 Rob U.S

    now my question is how can i get the records from the table such that the records should have Student_name,Student_country as same values.
    egg:in the above example Williams with China has two records but the student_no are different. i want those 2 records. here Student_no is the primary key.

    Thanks & Regards,
    raghunadhs.v
    Last edited by raghunadhs; Dec 5th, 2007 at 01:19 AM. Reason: for more clarity
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width