Progress and its annoying Parser

[bugg_tb]

SELECT 
 PUB.D2_SORD_DEL_HEAD.sdh_deliver_num
, PUB.D2_SORD_DEL_HEAD.sdh_deliver_name
, PUB.D2_SORD_DEL_HEAD.sdh_deliver_addr1
, PUB.D2_SORD_DEL_LINE.sdl_deliver_wght
, PUB.D2_SORD_DEL_LINE.sdl_deliver_vol
, PUB.D2_SORD_DEL_HEAD.sdh_deliver_date
, PUB.D2_SORD_DEL_LINE.soh_num
, PUB.D2_SORD_DEL_HEAD.sdh_del_status
, PUB.D2_SORD_DEL_HEAD.trad_code
, PUB.D2_SORD_DEL_HEAD.delivery_type
FROM PUB.D2_SORD_DEL_LINE 
INNER JOIN PUB.D2_SORD_DEL_HEAD 
ON (PUB.D2_SORD_DEL_LINE.sdl_deliver_date = PUB.D2_SORD_DEL_HEAD.sdh_deliver_date) 
AND (PUB.D2_SORD_DEL_LINE.sdl_deliver_num = PUB.D2_SORD_DEL_HEAD.sdh_deliver_num)
WHERE sdh_deliver_date = '2009/01/13'
AND sdh_del_status='001'
AND (trad_code='B15' 
Or trad_code='E74') 
AND delivery_type ='001'
GROUP BY sdh_deliver_num, sdh_deliver_name, sdh_deliver_addr1, sdl_deliver_wght, sdl_deliver_vol,
sdh_deliver_date, soh_num, sdh_del_status, trad_code, delivery_type

can anyone shed any light on why this wouldn't work? I've tried with and without aliases, but to no avail,

Caused by: java.sql.SQLException: [JDBC Progress Driver]:Non-group-by expression in select clause (7641)

Cheers

tom

 

[bugg_tb]

Turns out that if I remove all aliases and define full table paths in the grouping, it seems to work...

Eh?