postgres - group by on multiple columns - master/detail type table
- by smpillay
I have a table order(orderid, ordernumber, clientid, orderdesc etc.,) and a corresponding status for that order on an order_status table ( statusid, orderid, statusdesc, statusNote, statustimestamp)
say I have a record in order as below
orderid orderumber clientid orderdesc
1111 00980065 ABC blah..blah..
and a…