Re: I am having a problem combining Two SQL queries. Please Help
From: Ian (ian_at_NoWhere.com)
Date: 10/26/04
- Next message: Joe Palm: "RE: What stored procedures call this stored procedure?"
- Previous message: Joe Scalise: "Re: help with query please!!! max() and joins"
- In reply to: Ian: "I am having a problem combining Two SQL queries. Please Help"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 16:18:06 +0100
I HAVE DONE IT.
Select Q1.Q1ScenarioID, Q1.ScenarioOrder ,Q1.ScenarioName
,Q1.ScenarioDescription ,Q2.CountOfAction From
(SELECT tbl_BTP_Scenario.ScenarioID AS Q1ScenarioID,
tbl_BTP_Scenario.ScenarioOrder, tbl_BTP_Scenario.ScenarioName,
tbl_BTP_Scenario.ScenarioDescription
FROM tbl_BTP_Scenario Where tbl_BTP_Scenario.BTP_ID = 19) AS Q1
LEFT OUTER JOIN
(SELECT tbl_BTP_Scenario.ScenarioID,
COUNT(tbl_BTP_Instructions.InstructionID) AS CountOfAction
FROM tbl_BTP_Instructions INNER JOIN tbl_BTP_Scenario ON
tbl_BTP_Instructions.ScenarioID = tbl_BTP_Scenario.ScenarioID
WHERE (tbl_BTP_Instructions.ActionID = 20) AND (tbl_BTP_Scenario.BTP_ID =
19)
GROUP BY tbl_BTP_Scenario.ScenarioID) AS Q2
ON Q1.Q1ScenarioID= Q2.ScenarioID
ORDER BY Q1.ScenarioOrder
I Rock!!!
"Ian" <ian@NoWhere.com> wrote in message
news:uHyWxW2uEHA.1372@TK2MSFTNGP14.phx.gbl...
> Hi all
>
> I have these two queries.
>
> ONE
>
> SELECT tbl_BTP_Scenario.ScenarioID, tbl_BTP_Scenario.ScenarioOrder,
> tbl_BTP_Scenario.ScenarioName,
> tbl_BTP_Scenario.ScenarioDescription
> FROM tbl_BTP_Scenario Where tbl_BTP_Scenario.BTP_ID = 19 ORDER BY
> tbl_BTP_Scenario.ScenarioOrder
>
> TWO
>
> SELECT tbl_BTP_Instructions.ScenarioID,
> COUNT(tbl_BTP_Instructions.InstructionID) AS CountOfAction
> FROM tbl_BTP_Instructions INNER JOIN tbl_BTP_Scenario ON
> tbl_BTP_Instructions.ScenarioID = tbl_BTP_Scenario.ScenarioID
> WHERE (tbl_BTP_Instructions.ActionID = 20) AND (tbl_BTP_Scenario.BTP_ID =
> 19)
> GROUP BY tbl_BTP_Instructions.ScenarioID
>
>
> They both work fine by them selves but I am trying to combine Query Two
with
> Query One.
>
> So that I get an out put of this.
>
> ScenarioID, ScenarioOrder, ScenarioName, ScenarioDescription ,
> CountOfAction
>
>
> How can i do this please.
>
> Thanks,
>
> Ian
>
>
>
>
- Next message: Joe Palm: "RE: What stored procedures call this stored procedure?"
- Previous message: Joe Scalise: "Re: help with query please!!! max() and joins"
- In reply to: Ian: "I am having a problem combining Two SQL queries. Please Help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
