Code:
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
Caused by: java.sql.SQLException: [JDBC Progress Driver]:Non-group-by expression in select clause (7641)
Cheers
tom