Help with an SQL Query on the Logger

[Mr_toad1_2]

We are running UCCE 8.5(3) and need help with an SQL query. When I run the below I would also like to see skill group information(name preferably)? Any help would be greatly appreciated!

select * from dbo.t_Termination_Call_Detail where DateTime between '10-11-2012 00:00:00:00' and

'10-11-2012 23:59:59:59'

[david.macias · Accepted solution]

Do an outer join o the SkillGroupSkillTargetID of the TCD and the SkillTargetID on the Skill_Group table.

david

[Mr_toad1_2]

David, thanks for replying.  Unfortunitly I don't know enough about SQL to put that into a query and have it return data.  Would you be able to give an example on what the query would look like?

[Mr_toad1_2]

David, I was able to figure it out.  Thanks!