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