Results 1 to 2 of 2

Thread: Need help

  1. #1
    Join Date
    Oct 2012
    Posts
    4

    Need help

    Hello

    I've got a problem with a SQL-question:
    I have two tables, one Person with personalnumber and name, the other Subscription with personalnumber and Newpaper.
    I have done the SQL-question select Person.Name, Subscription.Newspaper from Person join Subscription on Person.personalnumber = Subscription.personalnumber;

    this question joins the two tables so I get a new table with the Names from Person and Newspaper from Subscription, now I want a table whitch has the column Name and column Count, the Names in one row and the amount of subscriptions each person have

    exampel
    Name Count
    Peter 2
    Anna 3
    John 0
    Nathalie 2

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Tags for this Thread

Posting Permissions

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