Link tables Using SQL In MS Access
In this video, let's look at how to link two tables using SQL in MS Access. This is a follow up to the previous video ( • How To Create One-to-Many Relationship in ... ) where we used the Edit Relationships wizard.
The query is as follows:
ALTER TABLE orders
ADD FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
This creates an identical output as the last video with customer_id as the foreign key in the orders table.