The SELECT statement tells the query optimizer what data to return, what tables to look in, what relations to follow, and what order ... SQL Server syntax. The short version of this is fairly simple.

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. <BR><BR>I've seen one site have an occasional issue where queries to a particular table (the ...