This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hey Guys,
I have an order by clause that orders by a joined column, however the join I want to order on the column or null if the join is null (ie i want it to do a left join rather than a join) how do I acheive this?
Cheers Owen |
|
|
Hi Owen, Im assuming you are writing a LINQ based query - so you probably want to do something like this? var query = Ive noticed and fixed a couple of bugs in this area recently so ping me offline and I can send you an updated build if you are keen.
Jeremy |
|
|
Hi, Can it (using a left join instead of inner join) be done when using API query? Cheers, Werner
|
|
|
I presume you are meaning you are wanting to construct the query using the querying API rather than using LINQ? In which case yes, you would specify this using Join.Outer. e.g. query.Join = Join.Outer<T1, T2>(T1JoiningOnField, T2JoiningOnField)
Jeremy |
|