>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