General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a patient table and a visits table.
Patient
Patient_ID
Name
Visit
Patient ID
Date
Treatment Type
Amt
I wish to write a SQL statement that will generate a cursor as follows
Patient_ID, Name, Amt_1, Amt_2, Amt_3
where amt_1,amt_2,amt_3 are expenses incurred for treatment type 1, 2 & 3 respectively. The output is actually sort of crosstab. All help appreciated. Thanks.
Best Regards
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only