Hi,
Im trying to wryte a one to many query:
I've follow this sample
https://www.lianja.com/community/sho...highlight=join
I expect multiple records for the same order.. but I get only the first row for each order.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
only this work, but I need a third table on the join
whats wrong?Code:select orders.orderid, orders.shipvia, order_details.productid from orders left outer join order_details on orders.orderid = order_details.orderid
thanks
Fabio