Skip to content
Advertisement

How to identity customer orders by customer IDs [closed]

Say for example I have table Customer and I have another table called orders. How to identify that each order belongs to that particular customer.

Advertisement

Answer

Use The Foreign Key On Order Table Of Customer Id

Visit This Link How To Add Foreign Key in Table-

https://www.w3schools.com/sql/sql_foreignkey.asp

and Write Query like Select * from Order_table where Customer_Id='1'

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement