Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Red face Unanswered: Query returns inconsistent results

    Hi there,

    I've written a simple query to return details on a garment (for use in an 'ordering' website using ASP).

    SELECT distinct season, style, cloth, name, Sketch_big, style_id, Sizes, fabric, prod_group
    FROM colours
    WHERE prod_group = 'belts'

    (the prod_group will be variable but i've been testing using belts).

    I know there should be 26 results returned. However, when i run the query it seems to be entirely random as to how many results are returned. (same problem happens using other garments)

    It's doing my head in!

    The table i am getting the result from - 'colours' is another query. Could this be where my problem lies?

    I'd be grateful for any help!

    Thanks,

    Susie

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Are your tables linked?

  3. #3
    Join Date
    Oct 2002
    Location
    UK
    Posts
    21

    Re: Query returns inconsistent results

    Can you post the source of the colours query as well?

    I can't see anything obviously wrong with the SQL you've already posted.

Posting Permissions

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