I think what I need is a self join, I'm just uncertain how to structure this. Here is the english.
I have one table. From that table I want
member name
member rx label
EARLIEST RX date
LATEST PRESCRIBING DOC
this information is found in several different records in the same table, but in the end I want only one line per member per rx label with the earlies rx date and the latest prescribing doc
Like I said, I think I can accomplish this with a self join, but I'm not sure how. Can anyone help?
I have one table. From that table I want
member name
member rx label
EARLIEST RX date
LATEST PRESCRIBING DOC
this information is found in several different records in the same table, but in the end I want only one line per member per rx label with the earlies rx date and the latest prescribing doc
Like I said, I think I can accomplish this with a self join, but I'm not sure how. Can anyone help?