?Joining Two Queries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

?Joining Two Queries

Author

Topic

Tony.Valenti
Starting Member

4 Posts

Posted - 2005-02-27 : 12:17:37

Right now I have two Queries that I've created:
What I'm wanting to do is graft everything from Query1 onto Query2 but only where Query1.UserID = Query2.UserID . Any suggestions on how I would go about doing this?

--Query 1
(
SELECT
PC1.ID,
PC1.UserID,
PC1.ModuleID,
PC1.ModifiedDate
FROM
Projex2_0_0_Cores PC1
WHERE
PC1.ModuleID = 369
)
--Query 2
(
SELECT
PC2.UserID,
MAX(PC2.CreatedDate) as CreatedDate
FROM
Projex2_0_0_Cores PC2
WHERE
PC2.ModuleID = 369
GROUP BY
PC2.UserID,
PC2.ModuleID
)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-27 : 12:19:24

what do you mean by graft?? how exactly?
some sample data and desired results would be nice.

Go with the flow & have fun! Else fight the flow

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-02-27 : 12:31:55

For starters, you might want to look at INNER JOIN and SELECT in Books Online.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources