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

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.

Code:

---

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

That should work fine, except that you are missing commas and spaces in your statement. Look at the end of each line.

Hello,

Thanks for your help. I think l was thinking too much like VB. I thought with concatenation you left out the commas.

Thanks very much,

Steve

why are you hardcoding sql into your application?. unless there is a really good reason this is an extremely bad idea. i terms of security, performance, modularity

Want to do something even cooler? Check it out:

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

That little @ sign is some powerful stuff...