ASP.NET

How to table join in sql

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

FROM Product

INNER JOIN Client

ON Product.ClientID=Client.ClientID;