I have a select stmt with the following output.
empID FirstName LastName Work_type Rate
00001 John Smith RE 20
00001 John Smith OT 40
00002 Bob Jackson RE 25
I'd like to make the change to get the following output
empID FirstName LastName RE_Rate OT_Rate
00001 John Smith 20 40
00002 Bob Jackson 25
Thanks in advance.