order detail page
I need to create an order detail page that has all the customer info, i.e. order number what they purchased, shipping info etc. Since I'm using the sample database from WA, I need to combine the data in both the order and orderdetails tables. I have tried using a join statement and when I put it into a repeating region the mysql balks at the limit as it is limiting by 10 so I can page through the orders.
Please let me know how I can combine these tables to create and admin interface to manage my orders.