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'