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; 

How to table join in sql

SELECT Product.ProductID, Client.ClientName, Product.ProductDate

FROM Product

INNER JOIN Client

ON Product.ClientID=Client.ClientID;

How to delete data in database sql server

DELETE FROM Client

WHERE Name='Dovi' AND Clientname='Mmoi';

All Data Delete:

DELETE FROM Client;

How to update data in sql server database

UPDATE Client

SET Name='Dovi', City='London'

WHERE CustomerName='Musha';

Click to execute .

How to insert data in sql database 

INSERT INTO Client
VALUES (name,address,City,...);

 

Column name and values :

INSERT INTO Client(name,address,city,...)
VALUES (kolom,span,vigas,...);

How to create table in sql server

Client Table :

Product Table:

Output