SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru dragonhawk's Avatar
    Join Date
    Apr 2002
    Location
    Melbourne
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server query help

    I have 2 tables as follows:

    -------
    Table1
    -------
    ID
    HeatID1
    HeatID2
    HeatID3

    -------
    Table2
    -------
    HeadID
    HeatValue


    If I select * from Table1, I would get the ID and the ID for each Heat, for example (1, 3, 2, 2)

    Instead of that, I would like to write a query that would return (1, Hot, Warm, Warm), which is the value in the HeatValue field in Table2. I'm sure this can be done, but I'm just not seeing how and it's driving me crazy!

    Hopefully someone can help me out here.

  2. #2
    SitePoint Guru dragonhawk's Avatar
    Join Date
    Apr 2002
    Location
    Melbourne
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Never mind... figured it out (finally)... funny how you always work things out after posting about it


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
  •