Writing a SQL statement on serveral lines [* Resolved *]

[steve_rm]

Hello

I have a SQL statement which is long. How do l write it so that it is on serveral lines.

This is what l have tried to do.

CnnStr = "SELECT student.studentID, student.FirstName, student.LastName" +
                "book.bookID, book.Title" +
         "FROM student, book" +
         "WHERE student.studentID = book.studentID";

This does not work, and anyone tell me how to do this.

Many thanks in advance,

Steve