I have database which that store the sold products in Orders Table and another table called Transaction to set the time and the total price for the individual order ,my question is: How to combined more than one order with only one Transaction number , If there is any tables that I should to create or any thing to do to achieve the desired result. Thanks
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
It looks like you're most of the way there, but the Foreign Key should go the other way around. The