Reserved word DESC workaround for JOIN statement

[neroe]

Hello

I've written the following SQL which works fine;

select members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO
from members
inner join bookings on members.REF = bookings.REF

I'd like to add one more field from another table. The name of the field is DESC and I had intended it look like this in the statement;

events.DESC

I get an 'incorrect syntax near 'DESC'' error because it is a reserved word. Is there anyway around this except for renaming the field?

Thanks.

 

[SimonSellick]

Put the column name in square brackets: [DESC]

HTH

 

[neroe]

Works perfect, thanks.

 

[simian336]

BTW DESC in SQL is short for Descending used in the order by clause.

Usually a good practice not to use reserved words.

Simi

 

[gmmastros]

I agree with Simi. If you don't have much code around that uses this column, now would be the best time to change the name. It gets much harder once you have a lot of code that uses it.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom