Newbie help with T-SQL joins

  • Thread starter Thread starter Patricia
  • Start date Start date
P

Patricia

I am learning MS Sql (have the evaluation edition) and
Visual Basic .net and I can't seem to get my joins to
work. My code seems ok (I am working from Rick Dobson's
book), I can get the data to a view when only using one
table, but when I join to another, the inner join shows
no records, and the left outer join shows the second
table's values as null. I have checked indexes, have
indexed both tables on the fields to join. Any idea what
I am doing wrong. Thanks.
 
Patricia said:
I am learning MS Sql (have the evaluation edition) and
Visual Basic .net and I can't seem to get my joins to
work. My code seems ok (I am working from Rick Dobson's
book), I can get the data to a view when only using one
table, but when I join to another, the inner join shows
no records, and the left outer join shows the second
table's values as null. I have checked indexes, have
indexed both tables on the fields to join. Any idea what
I am doing wrong. Thanks.
Click to expand...

I guess you are using ADO.NET. There's a special ADO.NET group:
microsoft.public.dotnet.framework.adonet
 
Hello,

Patricia said:
I am learning MS Sql (have the evaluation edition) and
Visual Basic .net and I can't seem to get my joins to
work. My code seems ok (I am working from Rick Dobson's
book), I can get the data to a view when only using one
table, but when I join to another, the inner join shows
no records, and the left outer join shows the second
table's values as null. I have checked indexes, have
indexed both tables on the fields to join.
Click to expand...

This is a VB.NET language group. Notice that you will have a better
chance to get an answer if you post to the ADO.NET newsgroup in future:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

Web interface:

http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet
 
Back
Top