Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    362

    Unanswered: view and distinct number

    I have 2 tables and I fetch the values of both in a view
    The tables are the cities and the forecast for each cities (many to many relation).
    I want to ask if a there is way to add at the view a distinct number for each "record" of the view .
    Something like that (I do not need the groub by)

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the GROUP BY is what makes it work
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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