SQL to retrieve current Group name for Workorder ID

Hi
Could you please point me in the direction of writing a sql statement to retrieve the current group name for a workorder id?
Thanks
Eric