Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 3703
    
    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?
 
 
subject: MS SQL JOIN query not returning all results
 
Similar Threads
sql server question
hOW TO EXCEUTE sQLPLUS AND SQL COMMAND USING JAVE
Getting classCastException while using DefaultTableModel
how to execute sqlplus and sql commands using java
Oracle Database SQL confusion