Hey jganders,

You have solved the problem with the Group_Concat. Took me a bit to wrap my head around it but here is how the ending query looked:

SELECT ORDER_INFO.InvoiceNumber,
ORDER_PASSTHROUGH.POrderID,
ORDER_SHIP_INFO.SShipName,
ORDER_SHIP_INFO.SStreet1,
ORDER_SHIP_INFO.SStreet2,
ORDER_SHIP_INFO.SCity,
ORDER_SHIP_INFO.SStateOrProvince,
ORDER_SHIP_INFO.SPostalCode,
ORDER_SHIP_INFO.SCountry,
ORDER_SHIP_INFO.ShipMethod,
ORDER_ITEMS.IFullSKU,
ORDER_ITEMS.IDescription,
ORDER_ITEMS.IQuantity,
ORDER_PASSTHROUGH.PPassValue,
ORDER_OPTIONS.OItemID,
GROUP_CONCAT(OOptionValue)
FROM ((((ORDER_INFO LEFT JOIN ORDER_SHIP_INFO ON ORDER_SHIP_INFO.SOrderID=ORDER_INFO.OrderID)
LEFT JOIN ORDER_ITEMS ON ORDER_ITEMS.IOrderID=ORDER_SHIP_INFO.SOrderID) LEFT JOIN ORDER_PASSTHROUGH ON ORDER_PASSTHROUGH.POrderID=ORDER_ITEMS.IOrderID)
LEFT JOIN ORDER_OPTIONS ON ORDER_OPTIONS.OItemID=ORDER_ITEMS.ItemID)
WHERE ORDER_INFO.InvoiceNumber=orderNumber
GROUP BY OItemID


Man, I really appreciate you pointing me to that. Works perfectly and is exactly what I was looking for!!!! I ended up being able to clean a bunch of crap out that I didn't need. Thank you for pointing me in that direction as well. I'm getting it, slowly, but I'm getting it.

DaK