Query multiple tables

[phabio]

Hi,
Im trying to wryte a one to many query:

I've follow this sample
https://www.lianja.com/community/sho...highlight=join

select orders.orderid, orders.shipvia, shippers.companyname, order_details.productid from orders left outer join order_details on orders.orderid = order_details.orderid inner join shippers on orders.shipvia = shippers.shipperid

I expect multiple records for the same order.. but I get only the first row for each order.

only this work, but I need a third table on the join

select orders.orderid, orders.shipvia, order_details.productid from orders left outer join order_details on orders.orderid = order_details.orderid

whats wrong?

thanks
Fabio

[josipradnik]

Is this better:

select orders.orderid, orders.shipvia, order_details.productid, shippers.companyname from order_details join orders on order_details.orderid=orders.orderid join shippers on orders.shipvia = shippers.shipperid

ORDERID SHIPVIA PRODUCTID COMPANYNAME

10248 3 39 Federal Shipping
10248 3 59 Federal Shipping
10248 3 1 Federal Shipping
10249 1 49 Speedy Express
10249 1 48 Speedy Express
10250 2 24 United Package
10250 2 10 United Package
10250 2 70 United Package
10251 1 31 Speedy Express
10251 1 5 Speedy Express
10251 1 6 Speedy Express

[phabio]

Ok, but if I've a order without a detail? This query work?
Tomorrow I try.
Tank fabio