SQL Join

Sharky Forums


Results 1 to 5 of 5

Thread: SQL Join

  1. 12-31-2002, 05:39 PM #1
    FMRock
    FMRock is offline
    Catfish
    Join Date
    Sep 2001
    Location
    Ft Myers FL
    Posts
    236

    SQL Join

    Im trying to join to identical tables, that say have 2 differnt states data. Because of the way the data is imported they cant be in one table. So I would like to make a view that has all the data in it. We are using a SQL Server 2000, and im sure this isnt that hard to do. Any help would be greatful.
    MSI K7T266 Pro2,AMD XP1600,Volcano 6CU+
    Crucial 512 MB PC2100,Min Maw Case
    WD 100 Gig HD,GF2
    -------------------------------------
    Dell Inspiron 8200. P4 1.7 384mb, 30 gig HD, ATI Radeon 9000
    Reply With Quote Reply With Quote
  2. 12-31-2002, 05:55 PM #2
    Grizzly
    Grizzly is offline
    Ursus Arctos Moderatis Grizzly's Avatar
    Join Date
    Sep 2000
    Location
    Providence, RI USA
    Posts
    3,077
    Are you familiar with the UNION operator? That would be one way to attack it.
    Reply With Quote Reply With Quote
  3. 12-31-2002, 05:59 PM #3
    FMRock
    FMRock is offline
    Catfish
    Join Date
    Sep 2001
    Location
    Ft Myers FL
    Posts
    236
    Ahh.. ill check that out. I have used that once or twice before but forgot about it. Ill google it and try it.

    Thanks Griz
    MSI K7T266 Pro2,AMD XP1600,Volcano 6CU+
    Crucial 512 MB PC2100,Min Maw Case
    WD 100 Gig HD,GF2
    -------------------------------------
    Dell Inspiron 8200. P4 1.7 384mb, 30 gig HD, ATI Radeon 9000
    Reply With Quote Reply With Quote
  4. 01-08-2003, 08:51 PM #4
    ksuohio
    ksuohio is offline
    . ksuohio's Avatar
    Join Date
    Oct 2001
    Location
    Atlanta, GA
    Posts
    2,721
    Originally posted by Grizzly
    Are you familiar with the UNION operator? That would be one way to attack it.
    Smart man!
    ---------------------------------------------------------------
    - Asus M50 Laptop - C2D T9300 - 4 gig RAM - Radeon HD 3650 - Vista x64 Ultimate

    - Intel i7-3770K - Asus P8Z77-V DELUXE - 32gig RAM - Radeon HD7970 Ghz - Plextor M3 256GB/120GB OCZ Vertex3
    - LG BluRay - Razor Blackwidow Ultimate Keyboard - Logitech G9x
    - HP ZR2740w/Asus LCD - W7 Ultimate
    ---------------------------------------------------------------
    Reply With Quote Reply With Quote
  6. 01-08-2003, 10:16 PM #5
    OS-Wiz
    OS-Wiz is offline
    Old School OCer OS-Wiz's Avatar
    Join Date
    Dec 2001
    Location
    St. Louis, Mo, USA
    Posts
    12,242
    SELECT COL1, COL2, ...
    FROM TAB1
    UNION ALL
    SELECT COL1, COL2, ...
    FROM TAB2
    The Money Trap = Intel i7 930 | Corsair H70 | ASUS P6X58D-E | 3 x 2GB G.Skill DDR3 2000 6-9-6-24 | EVGA GTX 580 DS SC | OCZ Vertex 2 90GB SSD | WD VelociRaptor | Klipsch ProMedia | Cooler Master HAF 932 | Antec TPQ-1200W | Dell U2711 2560 x 1440 27" | Windows 7 Ultimate 64-bit | APC RS1500
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules