ST Alpha - "Another option that might make more sense is to use a JOIN to a subquery. I'm not sure the syntax is exact but it's more "standard" than the concat" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 167

In response to "LIR: Jax. I think you can kinda "trick" it into generating a subquery like this using CONCATENATE" by kilboooo

Another option that might make more sense is to use a JOIN to a subquery. I'm not sure the syntax is exact but it's more "standard" than the concat

Posted by kilboooo (aka kkuphal) Oct 28 '08, 08:00

SELECT helpdesk_escalatedcount.[Taken By], helpdesk_notescalatedcount.LevelOneCalls, helpdesk_escalatedcount.LevelTwoCalls, [LevelTwoCalls]/[LevelOneCalls] AS PercentEscalated,
apptable.appcount
FROM helpdesk_escalatedcount

LEFT JOIN (SELECT name, COUNT(application) as appcount FROM othertable) ON othertable.name = helpdesk_escalatedcount.[Taken By]

INNER JOIN
helpdesk_notescalatedcount ON helpdesk_escalatedcount.[Taken By] = helpdesk_notescalatedcount.[Taken By];

Responses:

Yeah, I'm playing with this. It didn't like Concatenate, but I'm thiking you're on to something here. Thanks! -- nm - JaxSean Oct 28, 08:04 1
- Let me know how it works. It'll bug me unless I know it's right :) -- nm - kilboooo Oct 28, 08:14

Post a message top

Another option that might make more sense is to use a JOIN to a subquery. I'm not sure the syntax is exact but it's more "standard" than the concat

Replies are disabled on threads older than 7 days.