aspose file tools*
The moose likes JDBC and the fly likes MS SQL JOIN query not returning all results Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS SQL JOIN query not returning all results" Watch "MS SQL JOIN query not returning all results" New topic
Author

MS SQL JOIN query not returning all results

David J Smith
Greenhorn

Joined: Jun 09, 2009
Posts: 24
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

Joined: Jun 09, 2009
Posts: 24
By the way, Table1 is a view, not sure if this makes any difference?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Try putting the username in front of the table name, sometimes SQL server filters by user.


My Blog: Down Home Country Coding with Scott Selikoff
David J Smith
Greenhorn

Joined: Jun 09, 2009
Posts: 24
I'm logging into the server using the sa user so it should show everything no?
 
Consider Paul's rocket mass heater.
 
subject: MS SQL JOIN query not returning all results