Results 1 to 2 of 2

Thread: Query help

  1. #1
    Join Date
    Jul 2006
    Posts
    26

    Unanswered: Query help

    I have to tables, users and classes. I need to show the classes count of each user with user ID and i have to show those users as well .. with no classes. how to do it ..

  2. #2
    Join Date
    Jun 2008
    Location
    pakistan
    Posts
    109
    you mean each user have different classes ???

    you can use count function some thing like this

    select count(users),count(classes),userid,username from etc table check that one this is only the sample code make your question more understandable...

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
  •