I have a select statement that joins three tables. The statement is working fine in SQL Query Analyzer (returning correct number of rows), however, the same query ran on a search form on an ASP page returns 53 fewer rows? I have tried putting in more rows in the db, and same result through the asp page.
My table are items and prods, and my statement is as follows:
FROM items INNER JOIN
prods ON items.product = prods.product
This statement ran on SQL query analyzer returns 10738 rows, in the asp page it returns 10685 rows.
Any reason why this would happen? The asp page is created with FrontPage, using the above custome query as the record source. The connection is fine, the database is fine, and all columns and tables exist.
The results from the Query Analyzer are the correct returns results.
Let me know if you need more information.