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
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?