Results 1 to 2 of 2

Thread: distinct query help

  1. #1
    Join Date
    Sep 2007
    Posts
    1

    distinct query help > edited

    i'm in need of help woth this query, i've edited my post.

    just click the link below

    http://www.geocities.com/gateofgalesph/qry/index.html

    thank you
    Last edited by makotoken; 09-11-2007 at 07:22 AM. Reason: for a much more clearer sql query help

  2. #2
    Join Date
    Sep 2007
    Posts
    1

    distinct query help

    The query did return distinct records just as you had asked for. What exactly are you looking for it to return? Distinct customer IDs?, Last names?, etc... by including all of the fields behind the 'Distinct' keyword you are only filtering records where all of the fields are the same. If one field is different (ie. your 'tcno' fields) that is a separate 'Distinct' record...

Posting Permissions

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