I have three tables that I want to query When I try: Code Snippet var query = from a in TableA join b in TableB on a.FieldA equals b.FieldX join c in TableC on b.FieldM equals c.FieldR && b.FieldN equals c.FieldS && b.FieldO equals c.FieldT The query starts giving me syntax errors when I try the && b.FieldN equals c.FieldS line I've tried to put in brackets here there and everywhere, but to no avail. Any ideas? I've got around this using the old ANSI syntax (of putting in multiple b.Field? == c.Field?)
Read More...