DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: one to many rows across tables sqls

  1. #1
    Join Date
    May 2001
    Location
    scotland
    Posts
    1
    this is probally a basic question, I have serveral tables which have a one row to one row relationship my problem is with the one row to many rows
    eg
    one table with operation times - all times in a separate column in one table with the operation number to join it with other tables one of which is a table containing codes for what operations the patient has had during this theatre spell.
    Another table contains the staff present during the theatre spell a row for each member of staff
    I want to produce a report which produces 1 row in a report showing times operation1 ... operation99 staff1 ... staff99
    eg
    opno in ana in th out th op1 op2 op3 med1 med2 nur1 nur2
    123 10:00 10:10 10.45 AS3 DE6 DE4 S12 S34 N14 N50

    CAN ANYONE HELP???

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You can Matrix option in the Dev2000-Report.

Posting Permissions

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


Click Here to Expand Forum to Full Width