Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-24 : 09:06:20
|
| John Santos writes "I am trying to use the top statement with the following statement:SELECT * From Dealers INNER JOIN US_ZIP ON Dealers.ZIP = US_ZIP.ZIP where....When I insert it, like this:SELECT top 200 * From Dealers INNER JOIN US_ZIP ON Dealers.ZIP = US_ZIP.ZIP where .....I only get 52 results from my table, without it, I get over 1000.I assume it is only querying the top 200 records of both tables, when it actually has to query all records of both tables to find the matches, THEN return only the top 200 records found.Any suggestions on how to make this work?Thanks for your time. It is appreciated.John" |
|
|
|
|
|
Using Top statement with inner join on two tables