Как связать эти 2 таблицы, чтобы я потом мог выводить заказы отдельного пользователя?
CREATE TABLE [dbo].[Clients] (
[Login] NVARCHAR (50) NOT NULL,
[Password] NVARCHAR (50) NOT NULL,
[Email] NVARCHAR (50) NULL,
[Firstname] NVARCHAR (50) NULL,
[Secondname] NVARCHAR (50) NULL,
[Thirdname] NVARCHAR (50) NULL,
[Money] INT NULL,
PRIMARY KEY CLUSTERED ([Login] ASC)
);
CREATE TABLE [dbo].[Orders] (
[Id] INT NOT NULL,
[Date] DATETIME NOT NULL,
[Price] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);