Left join in SubSonic Problem?

This may not be exactly what you want , but the best way to do things like this in subsonic is with views, So create the select as a view and then use the view object in your code. In 3+ the linq makes it alot easier to accomplish what you are trying.

It looks to me like the and part of your query should really be a where condition (you're trying to filter your results based on the value of tableB. Colc being equal to 'some value'). So what I think your sql query should look like is: select ... from tableA left join tableB on tableA.

Cola=tableB. Colb where tableB. Colc='some value' or tableB.

Colc is null If that is the case then in SubSonic you would do: new SubSonic.Select() . From("tableA"). LeftOuterJoin ("tableB","Colb","tableA","Cola") .

Where("Colc"). IsEqualTo("some value") . Or("Colc").IsNull().

Thank you very much! – world_CN Oct 15 '09 at 1:03.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.