Yes, it is possible. The databinding in the grid does not depend on how exactly you retrieve the data, whether it's from one or multiple tables. You can simply pass the LINQ query or a collection of objects and it will bind to the returned result.
If you are using LinqDataSource or EntityDataSource you can use their Selecting event to preform a more complex LINQ query as shown here.
Again the actual approach of retrieving the data is completely irrelevant to the databinding in the grid.
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed