SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Stupid join question.
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

compound
Starting Member

7 Posts

Posted - 11/16/2006 :  12:20:12  Show Profile
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
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 11/16/2006 :  12:23:48  Show Profile
SELECT [Name] FROM Table1
UNION
SELECT [Name] FROM Table2
Go to Top of Page

compound
Starting Member

7 Posts

Posted - 11/16/2006 :  12:28:15  Show Profile
snSQL, Thank you! That is exactly what I needed!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000