Results 1 to 3 of 3

Thread: Simple Select

  1. #1
    Join Date
    Oct 2005
    Posts
    58

    Unanswered: Simple Select

    I am trying to select a particular record from a table and for some reason it only returns 1 record when I know there are at least 6. I've tried Rtrim and left to make sure that I'm getting the exact string. The "MyID" field is varchar(32) and the "ExpireDate field is datetime and I have tried the below. Any ideas what could be wrong?

    Select DISTINCT K.MyID, KP.[EXPIREDATE] --, K.ACTIVATIONKEY
    From [KEY] K INNER JOIN KEY_PRODUCT KP
    ON K.MyKey = KP.MyKey
    Where K.MyID = '013BEB73C2CF11D39F3600105A05264C'

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    please read the sticky at the top and supply what we need to help you

    Thanks
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Brett, perhaps you need a sticky reminding people to read the first sticky. That would save you some time.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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