same query getting different results

  • Thread starter Thread starter brendan.wong
  • Start date Start date
B

brendan.wong

hello. i'm using ASP (classic) to write a database driven
application. it's a really simple app where all i'm doing is pulling
data from the db and displaying it in a table. however, i'm having
problems with my query. i output the query, copied it, and ran it in
my Access db. the problem is that the # of records i get (56) when i
run the query in Access is way different than the # of records i get
(4) when i calculate the total programmatically. i have no idea
what's going on. it's the same query, but i'm getting different
results. has anyone experienced this problem before? i've always
worked with sql server before so maybe this is problem is specific to
Access. thanks
 
sure. the query is

SELECT A.field1, A.field2, A.field3 FROM table A INNER JOIN table B ON
A.id = B.id WHERE B.delivered = 'Y' ORDER BY A.id

i don't remember the exact names of the fields and tables, but that's
what it looks like. thanks
 
The syntax of your query seems alright - if you debug your ASP app can you
catch your SQL string and debug.print it to see whether it's adding something
else in there?

Damian.
 
Back
Top