show databases;
create database join_functions;
use join_functions;
Create table Orders (OrderID varchar(25), CustomerId int,  Product varchar(25),
 OrderDate date, ShipperID int);
Insert into Orders values ('10308', 2, 'Laptop', '2021-09-18', 3),
 ('10309', 37, 'Xbox', '2021-09-19', 2), ('10310', 77, 'Laptop', '2021-07-07', 1);
Create table Customers (CustomerId int, CustomerName varchar(25), 
Phone varchar(25), Address varchar(25), City varchar(25), Postalcode int, Country varchar(25));
Insert into Customers values (1, 'Mohamed Salah', '+2167676', 'Sousse Tn 2222', 
'Sousse', 2222, 'Tunisia'), (2, 'Emna Chachia', '+216879', 'Tunis Tn 4444', 'Tunis', 4444, 'Tunisia'),
(3, 'Souha Mabrouk', '+2167986', 'Annaba Algeria 85858', 'Annaba', 85858, 'Algeria');
Drop Table orders; 
Drop Table customers; 

select * from Orders;
select * from Customers; 
Select * From Orders right join Customers on Orders.CustomerId=Customers.CustomerId;