SQL incorrect syntax near a table name after FROM and before INNER JOIN.

Hi I have this SELECT query. I've tried excuting the query on the SQL Pane on Visual Studio 2008 and it works. However when I run the page (this is an asp.net page), it throws an SQL Exception saying I have an incorrect syntax near Schedules.

string selectSched开发者_如何学运维String = "SELECT Subjects.subject_title, Schedules.class_day, CAST(MIN(Schedules.time_in) AS varchar(10)) + ' - ' + CAST(MAX(Schedules.time_out) AS varchar(10)) AS Expr1" +
            "FROM Schedules "+ //The exception points here       
            "INNER JOIN Subjects ON Schedules.subject_id = Subjects.subject_id " +
            "INNER JOIN Student ON Student.section_id = " + currentSection + " " +
            "GROUP BY Subjects.subject_title, Schedules.class_day";

Any ideas? As I've said, I tried excuting this on the SQL pane and it worked. Is there any special condition in asp.net that I've missed or something?

---

You are missing any white space between the end of the first line and FROM

Change AS Expr1" to AS Expr1 "

---

This is because the concatinated string is not correct try:

string selectSchedString = "SELECT Subjects.subject_title, Schedules.class_day, CAST(MIN(Schedules.time_in) AS varchar(10)) + ' - ' + CAST(MAX(Schedules.time_out) AS varchar(10)) AS Expr1" +
            " FROM Schedules "+ //The exception points here       
            " INNER JOIN Subjects ON Schedules.subject_id = Subjects.subject_id " +
            " INNER JOIN Student ON Student.section_id = " + currentSection + " " +
            " GROUP BY Subjects.subject_title, Schedules.class_day";

Notice the empty spaces.