Appending ID's from two tables into one table/view

#1

Table A has unique student ID's (plus other info) and Table B has unique
Instructor ID's (plus other info) I need to combine the ID's from both tables
into a view or table that will contain a master list of all ID's

The end result is one column with ID's from both tables.

#2

I figure it out with a Union query into a view - thanks.

"TLuebke" wrote:

Quote:

Table A has unique student ID's (plus other info) and Table B has unique
Instructor ID's (plus other info) I need to combine the ID's from both tables
into a view or table that will contain a master list of all ID's

The end result is one column with ID's from both tables.

#3

Thank you for adding the answer yourself - this helped me out.

"TLuebke" wrote:

Quote:

I figure it out with a Union query into a view - thanks.

"TLuebke" wrote:

Table A has unique student ID's (plus other info) and Table B has unique
Instructor ID's (plus other info) I need to combine the ID's from both tables
into a view or table that will contain a master list of all ID's

The end result is one column with ID's from both tables.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Appending ID's from two tables into one table/view

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Appending ID's from two tables into one table/view - 05-12-2009 , 04:19 PM

RE: Appending ID's from two tables into one table/view - 05-12-2009 , 04:41 PM

RE: Appending ID's from two tables into one table/view - 08-06-2009 , 12:34 PM