I upgraded from MSDE to SQL server Express 2005. My asp code that has inner and outer joins in the SQL statements doesn't seem to work the same. I can write the SQL statement to I.E. and paste it in SQL Management studio and it give results. The same query running in ASP vbScript under IIS doesn't returns no records. If I simplfied the query to just one table, it will return records.
Any ideas on what the difference might be?