ASP.NET

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;