Professional Web Applications Themes

Join - ASP Database

table 1 (tblClubs) fields: clCode - clName 111 The Frogs 222 Easy riders 333 The butterflies table 2 (tblCalendar) fields: calDate - calHomeCode - calVisitorsCode 9/9/04 - 111 - 222 15/9/04 - 222 - 333 How to retrieve the name of the home playing club aswell as the name of the visitor in Sqlstring ?? I have now: sqlTxt = "SELECT * FROM tblClubs, tblCalendar WHERE clCode=calHomeCode OR clCode=calVisitorsCode" But when i want to display the Calendar : Response.Write RS("calDate") & " - " & RS("clName") & " - " & RS("clName") I have 2 times clName. I think i ...

  1. #1

    Default Join


    table 1 (tblClubs)
    fields: clCode - clName
    111 The Frogs
    222 Easy riders
    333 The butterflies


    table 2 (tblCalendar)
    fields: calDate - calHomeCode - calVisitorsCode

    9/9/04 - 111 - 222
    15/9/04 - 222 - 333

    How to retrieve the name of the home playing club aswell as the name of the
    visitor in Sqlstring ??

    I have now:
    sqlTxt = "SELECT * FROM tblClubs, tblCalendar WHERE clCode=calHomeCode OR
    clCode=calVisitorsCode"

    But when i want to display the Calendar :
    Response.Write RS("calDate") & " - " & RS("clName") & " - " & RS("clName")

    I have 2 times clName. I think i have to use a AS statement. But how?

    Thx for the help

    Maarten.











    Maarten Guest

  2. #2

    Default Re: Join

    SELECT C.calDate,
    A.Clname as HomeTeam,
    B.Clname as VisitingTeam
    FROM tblCalendar T
    INNER JOIN tblClubs A
    ON T.calHomeCode = A.ClCode
    INNER JOIN tblClubs B
    ON T.calHomeCode = B.ClCode

    --
    Roji. P. Thomas
    Net Asset Management
    https://www.netassetmanagement.com


    "Maarten" <com> wrote in message
    news:od%gd.5186$telenet-ops.be... 


    Roji. Guest

  3. #3

    Default Re: Join

    Hi Roji, Thx for the help. Little question: in the second inner join must ON
    T.calHomeCode notbe T.calVisitorsCode ?


    "Roji. P. Thomas" <com> schreef in bericht
    news:uSpH8$phx.gbl... 
    >
    >[/ref]


    Maarten Guest

  4. #4

    Default Re: Join

    Marteen,

    it should be

    SELECT C.calDate,
    A.Clname as HomeTeam,
    B.Clname as VisitingTeam
    FROM tblCalendar T
    INNER JOIN tblClubs A
    ON T.calHomeCode = A.ClCode
    INNER JOIN tblClubs B
    ON T.calVisitorsCode= B.ClCode


    --
    Roji. P. Thomas
    Net Asset Management
    https://www.netassetmanagement.com


    "Maarten" <com> wrote in message
    news:aX4hd.5484$telenet-ops.be... 
    >>
    >>[/ref]
    >
    >[/ref]


    Roji. Guest

Similar Threads

  1. Is left-join faster then inner join?
    By howachen@gmail.com in forum MySQL
    Replies: 5
    Last Post: March 5th, 07:11 AM
  2. FMS Join two flv...
    By Luiz Alberto in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: November 23rd, 02:51 PM
  3. Is self-join appropriate?
    By Michal Stankoviansky in forum MySQL
    Replies: 6
    Last Post: January 3rd, 08:42 PM
  4. Replies: 2
    Last Post: September 18th, 09:59 PM
  5. Select Left Join AND Right Join
    By David in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 15th, 03: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