Hi!

I don't quite understand what you mean. English is my second language, and even though I speak a lot of English it can be confusing when talking in terms. So pardon me for being a little "stupid" from time to time.

I will extend my question.

From the query I had written earlier the row comes out like: (Semicolons marks different columns.)

ID;Customer name;Customer address;Product number;Product name;Quantity;Price;Product number;Product name;Quantity;Price

2;Andy;Andy's way 2;24;Glue;3;35;39;Oyster;2;9

3;Tom;Tom's way 3;39;Oyster;2;9

I want it to be:

ID;Customer name;Customer address

Product number;Product name;Quantity;Price

Product number;Product name;Quantity;Price

2;Andy;Andy's way 2;

24;Glue;3;35

39;Oyster;2;9

3;Tom;Tom's way 3;

39;Oyster;2;9

So by this we can see that the first row (containing the order header) is always going to be the same, and after that there should be order item rows. In the database they are connected to each other by ID (orderadress.id_order_details and orderdetail.id_order_details) which will be the common denominator. But as far as the order item rows goes there might be 1 or a hundred of them.

How I made anything more clear, or am I just talking gibberish as usual? 😛

Thanks in advance!