![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | LINQ: Inner Join & Left Outer Join Q I am having trouble doing an inner join and a left outter join in LINQ. Table A has a primary key PKA Table B has a primary key PKB and a column with the foreign key PKA I have no problem doing this inner join where A.PKA == B.PKA but there is a third table C which has a foreign key PKB. The left outer join is on B.PKB and C.PKB where the select includes count of C records along with values from A and B. I have the SQL but I can't get my head around how to do the outer join and get the count. Could someone provide an example and/or point me to a suitable resource? MSDN just seems to muddy the waters on this topic. thank you A.G. |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Outer join for query | .NET General | |||
| join domain | Vista General | |||
| ??Trying to join newsgroups but cannot???? | Vista mail | |||
| can't join Domain | Vista installation & setup | |||