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