Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - LINQ: Inner Join & Left Outer Join Q

Reply
 
Old 08-30-2009   #1 (permalink)
Registered User


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46