Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. update ccc
  2. set RDate = b.Record_date,
  3. BP = b.BloodPressure
  4. FROM ccc a JOIN anthropometry b
  5. ON a.ID = b.ID and
  6. b.Record_date = a.Vdate
  7.  
  8. Table aaa
  9. ID VDate Visit
  10. 10003 2003-09-26 00:00:00.000 1
  11. 10003 2004-05-15 00:00:00.000 2
  12. 10003 2007-01-09 00:00:00.000 3
  13. 10003 2007-07-05 00:00:00.000 4
  14. Table bbb
  15. ID Rdate BP
  16. 10003 2003-09-26 00:00:00.000 89
  17. 10003 2004-05-17 00:00:00.000 70
  18. 10003 2007-01-12 00:00:00.000 95
  19.  
  20. I would want
  21.  
  22. ID VDate Visit RDate BP
  23. 10003 2003-09-26 00:00:00.000 1 2003-09-26 00:00:00.000 89
  24. 10003 2004-05-15 00:00:00.000 2 2004-05-17 00:00:00.000 70
  25. 10003 2007-01-09 00:00:00.000 3 2007-01-12 00:00:00.000 95
  26. 10003 2007-07-05 00:00:00.000 4 Null Null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement