Results 1 to 4 of 4

Thread: sub listing

  1. #1
    Join Date
    Dec 2006
    Posts
    8

    sub listing

    can we sub list record..?

    that is;

    like this:

    name 1-----product 1-------qty1
    ------------product 2-------qty2
    ------------product 3-------qty 3
    name 2-----product 1-------qty 4
    ------------product 5-------qty 5

    like this.. i've put lines to properly display tabs..

    by which method we can do that.. can we do this using join..?

    thanks in advance...

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    It can be done, but the method depends on your tools. Some DBMSs can do this in pure SQL, but the syntax varies. More usually it is done in the reporting tool.

  3. #3
    Join Date
    Dec 2006
    Posts
    8
    we want it in sql query.. not any additional tool.. our head told it can be done..

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Whose SQL are you using? Oracle, Microsoft, IBM. MySQL, ...?

Posting Permissions

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