AnsweredAssumed Answered

Need help w/ ExecuteSQL command

Question asked by StylisticGambit on Jan 29, 2016
Latest reply on Feb 4, 2016 by disabled_morkus

I work at a doctor's office.  Our database (not designed by me) stores patient test results in a table which includes a different field for each and every test we offer.


The resulting data looks something like this:

DATEPATIENTGLUCOSE_RESULTHEMOGLOBIN_A1C_RESULT
01/07/162285684
01/07/16228565.1
01/13/162285692
01/15/16228561094.8
01/20/16228564.5

 

I would like to create an ExecuteSQL command that would generate:

DATEPATIENTGLUCOSE_RESULTHEMOGLOBIN_A1C_RESULT
01/07/1622856845.1
01/13/162285692
01/15/16228561094.8
01/20/16228564.5


I've tried different variations of SELECT DISTINCT, UNION, and JOIN, but I'm not able to find something that does what I want.


Is such a thing impossible?  Can anyone help?

Outcomes