Need a Query on MSSQL which have the technician and the group they belong too

I need to have a query om MSSQL which have the technician and the group they belong to