Stupid join question. - 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

Old Forums

CLOSED - General SQL Server

Stupid join question.

Author

Topic

compound
Starting Member

7 Posts

Posted - 2006-11-16 : 12:20:12

I have to tables

Table1
Date Name
11/11/2006 John
11/11/2006 Kevin
11/11/2006 Don

Table2
Date Name
11/12/2006 John
11/12/2006 Eric

I need a list of all unique names from these two tables. I'm probably brain dead, but I can't join them right.

HELP!

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-11-16 : 12:23:48

SELECT [Name] FROM Table1
UNION
SELECT [Name] FROM Table2

compound
Starting Member

7 Posts

Posted - 2006-11-16 : 12:28:15

snSQL, Thank you! That is exactly what I needed!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources