Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    20

    Unanswered: SQL Query question

    I have a table with two value columns A and B(both are decimal)
    In my query I want to extract where the values in A is less than the values
    in B (A < B)
    Most of the results are correct, however there is a couple of lines where
    A is greater than B.
    Not sure what is wrong.
    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hmmm. Tricky to say what is wrong with your code without being able to see it. In short - I'm not sure what's wrong either
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2009
    Posts
    16
    Can you give us values for A and B where the validation fails? You said there are a couple of lines where A is greater than B, what is A and what is B?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What are the datatypes of columns A and B in your table?
    George
    Home | Blog

Posting Permissions

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