I am not big on sql but did a project recently and did some test code on a mysql database. From what I remember, if you have say 5 items in table A, and three items in table B, and you join them with A being the outer source and B being the inner, and say there are only two items that match the criteria yo want, you would get something like this
A B
value Null
value value
value Null
value value
where the rows with botch values are the rows that match the chriteria, and the rows with null are not.
In C# linq, if you do a join either way (seems that it doesn't matter which you choose to be the outer or inner source) it discards the non-matching ones automatically since they are objects.
Is there a way to keep those matches even if they are null?