Help with SQL Select Statement
Project ID: 1268954633
Project Details
- Status: Closed (Chosen Programmer: johninfl; Paid)
- Posted: 3/18/2010 at 19:23 EST
- Closed: 3/18/2010 at 22:24 EST
- Project Creator:
- Budget: $10-30
- Description: I have 4 SQL tables (Protocol, Citations, Arm_Groups, Links). "Protocol" table is the parent table, and Citations, Arm_Groups, Links are child tables that have a one-to-many relationship with Protocol table. In summary, Protocol table has 1 row of data and Citations, Arm_Groups, Links each have multiple rows.
The 4 tables have a common (linking) field of "Ident_org_study_id."
I have attached a sample of the data.
I am in need of a SQL select statement with the proper joins, union, where, groups, etc.
Note: I'll be using this SQL statement for a report, however, the report is separate from this project.
Regards,
Joe
- Tags:
| Project Bids |
| Programmer | Bid  |
Delivery Time | Time of Bid | Rating | |
| johninfl | $15 | 1 hour | 3/18/2010 at 20:47 EST |  (2 reviews) |
|
| Dear Sir: I am a professional software developer in the US with nearly 20 years of database application development experience. I have excellent communication skills and would truly enjoy helping you with this query. I work with SQL every day, and I have absolutely no doubt that I can perform this simple task for you in very short order. Thank you for your time, and I look forward to working with you. You will NOT be disappointed! | |||||
| benatusl | $20 | 1 day | 3/18/2010 at 20:15 EST | (No Feedback Yet) | |
| i can get this done for you with extra tips | |||||
