Parent Child Order number Order Number Order Status 11111 11111 Submitted 11121 11111 Processing 11131 11111 Shipped 11121 Hold 11131 Submitted 11131 Processing 11131 CancelledUsing a SQL, how would i go about getting the last possible order status?
Select a.order_no, a.order_total, b.order_status, b. clerk; from parent a, child b ; where a.order_no=b.order_no; into cursor mysqlresultsthanks in advance for any help!!