SQL query question

    Date: 01/25/07 (SQL Server)    Keywords: no keywords

    I have a table of scores that I need to query. There are multiple scores per row. The scores are stored numerically, but have a text equivalent stored in a separate table.

    So my scores table has other fields as well as score fields with the scores stored numerically, for instance:
    iReader1Score
    iReader2Score
    iReader3Score

    My scoresText table has the text equivalent of the scores and an iReaderScore that matches with the iReaderXScores in the scores table:
    iReaderScore
    sScoreText

    I need to extract the other data from the scores table as well as my scores displayed as their text equivalents.

    Any help would be appreciated. Let me know if more information is required.

    (x-posted)

    Source: http://community.livejournal.com/sqlserver/55654.html

« ActiveX/vbscrpt and... || SQL question Syntax problem... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home