Aug 18, 2010 at 12:49 PM
Edited Aug 18, 2010 at 2:23 PM
Without using a stored procedure or view can I mimic a left outer join in a RunSelect statement or some other way.
Select LastName from tblPerson left outer join tblPerson on tblPerson.PersonId = tblCars.PersonId
I tried the following in a run select:
person.runselect(function(x) x.CarEntity is nothing | x.CarEntity.Make = "Mazda") but I SqlException error on the statement execution in the generated.cs class for this object.