This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS SQL JOIN query not returning all results

 
David J Smith
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am using the Microsoft SQL Server JDBC Driver 2.0.
I have the following query

When I run this in SQL Server Management Studio I get 176 rows returned, however when I run it using the JDBC Driver with the following command I only get 24 rows.

I am completely stuck, any help would be greatly appreciated.

David.
 
David J Smith
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By the way, Table1 is a view, not sure if this makes any difference?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4015
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try putting the username in front of the table name, sometimes SQL server filters by user.
 
David J Smith
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm logging into the server using the sa user so it should show everything no?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic