I'm using .NET 4.0, SQL Server, looking to do an inner join across two databases on the same server. Subsonic doesn't seem to like this. Any ideas?
You can write a stored procedure and join tables in it