General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>The DESC is a subclause of the ORDER BY clause in the SELECT-SQL statement.
Hey Sergey!
here is the statement. I wouldn't think that "Process.desc" could cause the error, but "Desc" is a reserved word... I don't generally watch out for reserved words.. but I will in the future! Thanks!
SELECT Linelist.line_no, Linelist.service, Process.process_id,;
Process.temp, Process.density, Process.desc;
FROM linelist LEFT OUTER JOIN process ;
ON Linelist.line_no = Process.process_id;
ORDER BY Linelist.line_no
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only