>You say to you have no other information, then you say that you do have order details... Why not adding the total amount of the order with the date? What about the customer? No customers are attached to your orders?
>
I'm working with DS/TA combination. The TA for Orders table has only two fields from the Orders table (PK and OrderDate).

Now I want to return a query to include items count and total price for the order. Does it mean that I have to add these two fields into the TA?

Thanks again.