Thank you for your help!!

>>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!!
>
>Select a.order_no, a.order_total, b.order_status, b. clerk ;
>from parent a inner join child b ;
>on a.order_no=b.order_no ;
>group by a.orde_no ;
>into cursor mysqlresults
>
>Cetin