I just finished work on an SQL_Engine that allows you to do exactly what you want.

Joining ADO.Net DataTables http://home.hot.rr.com/graye/Article...TableJoins.htm
In-Memory SQL Engine http://home.hot.rr.com/graye/Articles/SQL_Engine.htm