DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cross tab query

  1. #1
    Join Date
    Jul 2004
    Location
    Pakistan
    Posts
    46

    Cross tab query

    hi
    i have a bit complex query. just describing here a simple version to tell u what i want actually...i have three tables QUOTATIONS, SUPPLIER and PRODUCTS
    i need a report...i will give quotation number and agains that quotaion number i need products_id from PRODUCTS and then agains that produsc_id i need supplierid from SUPPLIER...so report will seem as bellow

    product_id product_name supplier_id1 supplier_id2 ....supplier_idn

    it means that i dont know how many supliers are there for this product...i have more supplires o i will have more columsn in the result of query..kindly tell me how to catter this
    Regards
    Salman Ahmed Qureshi
    Lahore, Pakistan

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Please refer Tom Kyte's Book "Expert one-on-one".

    You will see a generalized PKG that solve your problem.

    Tamil

Posting Permissions

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


Click Here to Expand Forum to Full Width