Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    21

    Unanswered: Help Reqd Urgently (SQL Query)

    Pls consider the following table:---


    Table Name: ChemoAdmin

    Fields:

    Field Name: Field Type: Typical Value:

    patientID (Varchar 10) XYZABC001
    stationDate (DateTime) 09/17/2004
    drugName (Varchar 25) Drug 1
    dose (Numeric) 5
    doseUnit (Varchar 5) mg


    I require the following output using one query:---


    DATE 09/17/2004 09/21/2004

    Drug 1 5 mg Nil
    Drug 2 2 mg 4 mg
    Drug 3 Nil 1 mg



    Pls help.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Sorry, but I'm confused. What is your question?

    -PatP

Posting Permissions

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