View_Order_Details

SELECT DISTINCT
    dbo.Orders.OrderID, dbo.Orders.UserName, dbo.Orders.ProdName, dbo.PaymentTypes.PaymentTypeName, dbo.Shippers.ShipperName, dbo.Orders.CustEmail, dbo.Orders.DeliveryNotes, dbo.Orders.OrderAmount
FROM
    dbo.PaymentTypes INNER JOIN
        dbo.Orders ON dbo.PaymentTypes.PaymentTypeID = dbo.Orders.PaymentTypeID INNER JOIN
        dbo.Shippers ON dbo.Orders.ShipperID = dbo.Shippers.ShipperID INNER JOIN
        dbo.aspnet_Users INNER JOIN
        dbo.CustGroups ON dbo.aspnet_Users.GroupID = dbo.CustGroups.GroupID ON dbo.Orders.CustID = dbo.aspnet_Users.UserId