Results 1 to 6 of 6

Thread: Append 2 Selects? [resolved]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member blindlizard's Avatar
    Join Date
    Feb 2001
    Location
    Austin, TX - United States of America
    Posts
    1,141

    Append 2 Selects? [resolved]

    I need to do something like this in MS SQL Server:
    Code:
    select startdate from classes 
    append 
    select startdate from events
    which should return the startdates from both tables in one recordset, but does not. I only get the startdates from the classes table, not from the events table.

    I think I use to do this in my old Oracle days, does SQL Server have something like it?
    Last edited by blindlizard; Dec 9th, 2003 at 11:50 PM.
    I drink to make other people more interesting!
    [vbcode]On Error GoTo Bar[/vbcode]
    http://www.monsterlizard.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width