Professional Web Applications Themes

HELP -- joining tables - Microsoft SQL / MS SQL Server

there are 2 tables: taJetPlane ID Desc --- ------------- 1 US AIRFORCE THUNDERBIRDS 1 US ARMY PARACHUTE TEAM GOLDEN KNIGHTS 2 AEROSHELL ACROBATIC TEAM 2 LIMA LIMA FLIGHT TEAM 3 A10 THUNDERBOLT 3 UH-60 BLACKHAWK HELICOPTER 4 LIQUID X FREESTYLE 2003 PRO TOUR 4 MUNSON SKI & MARINE SHOW TEAM taJetGroups ID Desc ---- --------------- 1 HEADLINERS 2 CIVILIAN AIRCRAFT 3 MILITARY AIRCRAFT 4 SHELL EXTREME WATER SHOW Question is , is it possible to get this kinda result: ------------------------------------------------- HEADLINERS CIVILIAN MILITARY SHELL AIRCRAFT AIRCRAFT EXTREME WATER SHOW ----------------------------------------------------- US AIRFORCE AEROSHELL UH-60 BLACKHAWK LIQUID X THUNDERBIRDS ACROBATIC . ...

  1. #1

    Default HELP -- joining tables

    there are 2 tables:

    taJetPlane
    ID Desc
    --- -------------
    1 US AIRFORCE THUNDERBIRDS
    1 US ARMY PARACHUTE TEAM GOLDEN KNIGHTS
    2 AEROSHELL ACROBATIC TEAM
    2 LIMA LIMA FLIGHT TEAM
    3 A10 THUNDERBOLT
    3 UH-60 BLACKHAWK HELICOPTER
    4 LIQUID X FREESTYLE 2003 PRO TOUR
    4 MUNSON SKI & MARINE SHOW TEAM

    taJetGroups

    ID Desc
    ---- ---------------
    1 HEADLINERS
    2 CIVILIAN AIRCRAFT
    3 MILITARY AIRCRAFT
    4 SHELL EXTREME WATER SHOW


    Question is , is it possible to get this kinda result:

    -------------------------------------------------
    HEADLINERS CIVILIAN MILITARY SHELL
    AIRCRAFT AIRCRAFT EXTREME
    WATER SHOW
    -----------------------------------------------------
    US AIRFORCE AEROSHELL UH-60 BLACKHAWK LIQUID X
    THUNDERBIRDS ACROBATIC . FREESTYLE
    . .
    US ARMY . . .
    PARACHUTE . .
    TEAM GOLDEN .
    KNIGHTS

    -----------------------------------------------------

    thanks in advance!



    JVince Guest

  2. #2

    Default Re: HELP -- joining tables

    Hi

    It seems you probably require a cro

    "JVince" <com> wrote in message
    news:074401c35626$2e643150$gbl... 


    John Guest

  3. #3

    Default Re: HELP -- joining tables

    Hi

    The following gives a list of links for crosstab queries which is what you
    probably require.

    http://tinyurl.com/i9mt

    John

    "JVince" <com> wrote in message
    news:074401c35626$2e643150$gbl... 


    John Guest

Similar Threads

  1. Joining three tables
    By DettCom in forum Coldfusion Database Access
    Replies: 4
    Last Post: July 19th, 06:12 PM
  2. Joining Tables
    By AMARITA in forum Coldfusion Database Access
    Replies: 4
    Last Post: September 20th, 02:02 PM
  3. Joining tables, Please help
    By Student_bob in forum Coldfusion Database Access
    Replies: 4
    Last Post: April 19th, 08:49 AM
  4. joining 3 tables?
    By siti_nana in forum Dreamweaver AppDev
    Replies: 2
    Last Post: February 27th, 08:16 AM
  5. joining several tables
    By james in forum IBM DB2
    Replies: 3
    Last Post: October 17th, 01:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139