What is this all about! Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join<BR><BR>SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId <BR>FROM (tblArtists <BR>INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) <BR>LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId <BR>ORDER BY surName ASC, firstName ASC<BR><BR>Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?