tags:

views:

44

answers:

0
+1  Q: 

Subsonic - Get All Columns From Joined Tables

How do I display columns from both tables with an "InnerJoin" from SubSonic?

var myQuery = New SubSonic.Select().From(TableObject1)
                          InnerJoin(TableObject2.ID,TableObject1.ID)

related questions

Why does wrapping an Excel array formula in a SUM not produce the sum of the contents in this case?
How could I rewrite a query without using joins
Inner Join with Subsonic
MySQL Query to create a "bump-system" for a forum I am making
Mysql Query not working
Mysql order by rating - but capture all
How to use INNER JOIN in the scenario?
optimize SQL query
Can anyone show me why my SQL query isn't working (see details)?
SQL query : inner joins optimization between big tables
SQL products/productsales
MySQL join query help
Inexplicable inner query
Why doesn't this SQL statement work?
How do you combine an inner and outer join in mysql
What's wrong with my MySQL query?
SQL Select statement with Inner Join help
LINQ To SQL Weird Join Issue
Is seven inner joins in a query too much?
MySQL correlated subquery
Interesting Many-many sql join.
LINQ inner join betwenn Enumerable and DB Table
Using DISTINCT inner join in SQL
Inner join across multiple access db's
SQL: inner join on alias column