Posted by leupat on 02/18/06 02:24

Hello everybody !!

I have a little problem with request.

I have 2 tables like that :

Table 1: T_Product
IdProduct
ProductName
IdSupplierPart1
IdSupplierPart2
IdSupplierPart3
....
IdSupplier10

Table 2: T_Supplier
IdSupplier
SupplierName
Adress
....

For one product we can have many supplier.

How to received its name(ProductName) and names of each suppliers
(SupplierName) for 1 product into only 1 request ??

Thanks
Best regards.

• Next in forum: Re: Join with many parts into only 1 request
• Prev in forum: Re: Bugs
• Thread view: Join with many parts into only 1 request

[Reply to this message]