- (select ar.deliverydate from ar where ar.id=ac.trans_id),
- (select ar.transdate from ar where ar.id=ac.trans_id),
- (select ap.transdate from ap where ap.id=ac.trans_id),
- (select gl.transdate from gl where gl.id=ac.trans_id),
+ (SELECT ar.deliverydate FROM ar WHERE ar.id=ac.trans_id),
+ (SELECT ar.transdate FROM ar WHERE ar.id=ac.trans_id),
+ (SELECT ap.transdate FROM ap WHERE ap.id=ac.trans_id),
+ (SELECT gl.transdate FROM gl WHERE gl.id=ac.trans_id),