VB.NET Trying to get multiple Tables of in ASP.NET Page

I am trying to get data from 3 different tables in my asp.net page.
The scenario is as follows:

its a page where the owner of the site can see all the orders received.

The tables involved are Orders, Order Details and Customers.

I am using DataGrid. Now i want to show the First and the last name of the customer on the Orders Received Page.

All the new orders are getting saved in Orders Table and a im also storing the Customer ID in the Orders Table.

I want to show the name of the customer instead of the customer ID on the Orders Received Page.

Now i have already used the Inner join command of SQL to Join The Orders.orderID and OrderDetail.OrderID and getting the Data from the 2 tables but i also want to join Order.CustomerID and Customer.CustomerID so that i can get the Full Name of the customer.

How should i make the SQL query and how which dataset should i fill. I know how it can be done in traditional ASP though.

I hope was clear. Help would be appriciated.

Thanks
Kamran.