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

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

Code:
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
Code:
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