Results 1 to 4 of 4

Thread: sql query

  1. #1
    Join Date
    Sep 2003
    Posts
    14

    Post Unanswered: sql query

    1
    Last edited by hallosenthil; 10-03-03 at 17:34.

  2. #2
    Join Date
    Jul 2003
    Location
    india
    Posts
    15
    HI, for your first question try with the following
    SELECT D.initials || D.surname as DoctorName, Pe.initials || Pe.surname as Personnam, Pe.membership_number As membername FROM DOCTOR D, MEMBERSHIP M, PERSON PE,
    PROVIDED_SERVICE PS
    WHERE
    PE.membership_number = M.membership_number AND
    PE.person_number = PS.person_number AND
    D.doctor_number = ps.doctor_number ;

  3. #3
    Join Date
    Jul 2003
    Location
    india
    Posts
    15

    Re: sql query

    can you give me some detail description for your second question.

    Chalam N

  4. #4
    Join Date
    Sep 2003
    Posts
    14
    1
    Last edited by hallosenthil; 10-03-03 at 17:33.

Posting Permissions

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