Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports XI and Progress 10.1B

Status
Not open for further replies.

jdgreen

Technical User
Mar 21, 2001
144
US
I am trying to run a query from Crystal Reports using a max SQL command. All I get is a syntax error. The code is below:
SELECT DISTINCTROW
Max(comh_corder_version_head.covh_due_date) AS LastOfcovh_due_date,
Max(comh_corder_version_head.covh_order_number) AS MaxOfcovh_order_number, comh_corder_version_head.covh_vin_number,
Max(comh_corder_version_head.corder_version_head_obj) AS MaxOfcorder_version_head_obj
FROM comh_corder_version_head
GROUP BY comh_corder_version_head.covh_vin_number;

It obviously is not liking the max command.

John Green
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top