Skip to content
Advertisement

group by order but found SELECT syntax

A select SQL with a subquery that contains a descending sort and inner join to link unto saem id (patid). Once this sort subquery is done I will make it a view query to be used by another SQL which is not working. Using WINSQL with Cache database.

The idea is to sort data_of_assessment in Descending order

Error message:

[%msg: < ) expected, IDENTIFIER (order) found^SELECT c1 . patid , c1 . date_

Sample Data:

Advertisement

Answer

Presumably, what you want is the most recent assessment for each patid:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement