Sql

[Joe_Fox]

Does anybody know how I can solve the following:

I'm trying to run the following query:

select  Subject.ID,
        Subject.Name, 
        Files.File_Name,
        Files.Date_Created,
        Files.Date_Closed
 
from Subject
inner join Files
 
on Subject.ID=Files.ID
order Subject.ID

The problem is that the columns named 'Name' and 'ID' are stored SQL procedures and when I write the SQL, they turn to blue, as the query analyzer recognises then as commands.

Does anyone know how do I get around this problem? Just to let you know that I cannot rename the column headers.

If anyone can help that'd be brilliant.

Thanks,
Joe

 

[Joe_Fox]

Sussed it out. For information you put double quotes around the column header.

 

[Matt_B]

I hate joins with a passion. Refuse to use them!

 

[pds]

SQL piggy!

 

[Melton Fox]

SQL piggy!

:icon_lol:

I seen it

 

[Steven]

SQL piggy!

Were you a member of the cast of Deliverance?