Hello! I have a small question regarding a SQL process. I am trying to get last record information from a table. This process uses two tables: 1 parent table and 1 child table. The data is going to a report.

The parent tables hold five fields, one of which is an order number field

The child table holds 50 fields, the two relevant fields are:
1. order number
2. order status

The tables appears as:

Parent                  Child
Order number            Order Number     Order Status
11111                   11111            Submitted            
11121                   11111            Processing
11131                   11111            Shipped
                        11121            Hold 
                        11131            Submitted
                        11131            Processing
                        11131            Cancelled

Using 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 mysqlresults

thanks in advance for any help!!