How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Scott Your Own Question
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Homework Datatbase Management, clinical course. Trying to

Customer Question

Homework Datatbase Management, clinical course. Trying to find the relationship to when tests are done, prescriptions are given AFTER an encounter date. Running my sql in Flamerobin(firebird), I get no results.
SELECT ENCOUNTER_INTERVENTION.ENC_INT_DATE, PRESCRIPTION.RX_DATE, TEST_RESULT.TEST_RESULT_DATE, ENCOUNTER.ENC_DATE, ENCOUNTER.ENC_ID
FROM ENCOUNTER_INTERVENTION JOIN PRESCRIPTION USING (ENC_ID)
JOIN TEST_RESULT USING (ENC_ID)
JOIN ENCOUNTER USING (ENC_ID)
WHERE ENC_DATE > '01/01/2000'
OR ENC_DATE < '05/01/2016'
OR ENC_DATE = '10/12/2012'
Submitted: 1 year ago.
Category: Homework
Customer: replied 1 year ago.
Mis-question> should be: A query that involves at least 3 tables. Include at least one attribute from each table in the SELECT satement
Expert:  aitizaz replied 1 year ago.
Hello and welcome to Just Answer! i amCustomerand i will help you todaycan you provide me the format of the three table along with some sample data? Also, do give a TEST RUN of the requirement ( i.e. prescriptions are given after an encounter date, please demonstrate with example)