How to create foreign key in sql

Order table(ord_Id int NOT NULL,OrderNo int NOT NULL,Client_Id int,PRIMARY KEY (ord_Id),CONSTRAINT fk_ClientOrder FOREIGN KEY (Client_Id)REFERENCES Client(Client_Id))

How to create primary key in sql

Client Table
(
Client _Id int NOT NULL PRIMARY KEY,
Name varchar(50) NOT NULL,
Address varchar(250),
City varchar(15)
)

Client ID is a primary key.

How to union operator in sql database

SELECT City FROM Client
UNION
SELECT City FROM Supplier
ORDER BY City;

How to full join in sql

SELECT Client.ClientName, Product.ProductID
FROM Client
FULL OUTER JOIN Product
ON Client.ClientID=Product.ClientID
ORDER BY Client.ClientName;

How to right join in sql

SELECT Product.ProductID, Client.Name

FROM Product

RIGHT JOIN Client

ON Product.ClientID=Client.ClientID

ORDER BY Product.ProductID;

How to left join in sql

SELECT Client.ClientName, Product.ProductID

FROM Client

LEFT JOIN Product

ON Client.ClientID=Product.ClientID

ORDER BY Client.ClientName;

How to INNER Join in sql database

SELECT Client.ClientName, Orders.OrderID
FROM Client
INNER JOIN Orders
ON Client.ClientID=Orders.ClientID
ORDER BY Client.ClientName;