MGA555
MGA555
In case this fell off your radar screen, just a polite reminder that I am still stuck on this. thanks
I'm pretty sure the table structure is set up correctly. The custorder table primary key is custorder_id. The orders table (which contains the line items for an order) primary key...
I don't doubt that I am doing something wrong, but just can't figure out what it is.
I'm not sure how to answer that. I want a grid of orders, but listing the custorder ID (which is the "order" number, and the order_id (which is the line...
I just changed the database so that the second order actually has a line item. I still only get 1 row for the custorder_ID of 34779. So it is like...
I may have inadvertently broken some MySQL rule, but I did not think I had. Here are the tables and the primary keys: Table Key custorder custorder_id orders orders_id Since...
I sent you the sample tables, and some thoughts/observations last Thurs and Fri AM. I hope you got them, but am posting this in case they went to a junk...
Yes, that;'s me! Sorry I did not mention that. I thought the subject line would make things clear.
Do you have any insight on the problem I am having?
You overlooked the issue, that I would need a right join, so as to capture any Custorder which does not have an Order. That results in multiple records with a...