Innerjoin with more than one column

Im using subsonic 2.1

I have 2 tables and i am joining them with 2 columns

How do i do inner join in select query.

to be more precise how do i do same with subsonic what im doing in below query.

select * from table1 t1
inner join table2 t2
on t1.col1 = t2.col1 and t1.col2 = t2.col2

thanks.

SP

Try this I'm not sure if it will work

new Select().From(Table1.Schema).InnerJoin(Table2.Col1Column, Table1. Col1Column).InnerJoin(Table2.Col2Column, Table1. Col2Column)

Thanks for your reply...

 I tried it.

When I get sql statement using BuildSqlStatement() I get

select * from table1
inner join table2 on table1.col1= table2.col1
inner join table2 on table1.col2= table2.col2

which is incorrent.

thanks

SP

It looks like SubSonic's SqlQuery only supports joining on one column you can use InlineQuery :( or submit a patch that fixes this

 thanks for your help.

I will try to explore it. and if i have a solution, will let you know. meanwhile if anyone of you have a solution please post it.

thanks

sp.