UNION HELP - 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 2005 Forums

Transact-SQL (2005)

UNION HELP

Author

Topic

joemama
Posting Yak Master

113 Posts

Posted - 2007-08-23 : 18:49:44

I HAVE THIS QUERY THAT GIVES ME ALL GROUP NAMES BY TOPIC ID

SELECT TOP (100) PERCENT dbo.WMM_IMPACTED_GROUPS.TopicID, dbo.WMM_IMPACTED_GROUPS.ImpactedID
FROM dbo.WDD_GROUP_NAMES LEFT OUTER JOIN
dbo.WMM_IMPACTED_GROUPS ON dbo.WDD_GROUP_NAMES.GroupID = dbo.WMM_IMPACTED_GROUPS.ImpactedID
WHERE (dbo.WMM_IMPACTED_GROUPS.TopicID = 19)
ORDER BY dbo.WDD_GROUP_NAMES.GroupID

I WANT TO DO A UNION WITH THE FOLLOWING TABLE

SELECT TOP (100) PERCENT
FROM dbo.WDD_GROUP_NAMES

TO GIVE ME THIS

1 IT 19 1
2 MRA'S 19 2
3 ADMIN 19 3
4 INVESTIGATORS 19 4
5 BIOSTATISTICIANS 19 5
6 PROGRAMMERS 19 6
7 RA'S NULL NULL
8 PROJECT MANAGERS 19 8

I have to be able to display ALL group names that have by topic ID and also show the ones that do not have that topic id

any help would be appreciated

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-08-24 : 04:18:37

SELECT TOP (100) PERCENT dbo.WMM_IMPACTED_GROUPS.TopicID, dbo.WMM_IMPACTED_GROUPS.ImpactedID
FROM dbo.WDD_GROUP_NAMES LEFT OUTER JOIN
dbo.WMM_IMPACTED_GROUPS
ON dbo.WDD_GROUP_NAMES.GroupID = dbo.WMM_IMPACTED_GROUPS.ImpactedID
AND dbo.WMM_IMPACTED_GROUPS.TopicID = 19
~~WHERE (dbo.WMM_IMPACTED_GROUPS.TopicID = 19)~~ORDER BY dbo.WDD_GROUP_NAMES.GroupID

Mark

joemama
Posting Yak Master

113 Posts

Posted - 2007-08-24 : 12:36:38

You Rock!

thanks

quote:
Originally posted by mwjdavidson

SELECT TOP (100) PERCENT dbo.WMM_IMPACTED_GROUPS.TopicID, dbo.WMM_IMPACTED_GROUPS.ImpactedID
FROM dbo.WDD_GROUP_NAMES LEFT OUTER JOIN
dbo.WMM_IMPACTED_GROUPS
ON dbo.WDD_GROUP_NAMES.GroupID = dbo.WMM_IMPACTED_GROUPS.ImpactedID
AND dbo.WMM_IMPACTED_GROUPS.TopicID = 19
~~WHERE (dbo.WMM_IMPACTED_GROUPS.TopicID = 19)~~ORDER BY dbo.WDD_GROUP_NAMES.GroupID

Mark

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources