Select * ;
    From Invoice ;
    Where ;
        InvoiceId = 3 And ;
        Between( InvoiceDate, {12/01/01}, {12/31/01} ) ;
    Into Cursor qroInvoices

Use Dbf("qroInvoices") Again In 0 Alias qInvoices
Select qInvoices
Index On InvoiceId Tag InvoiceId

Select 
qInvoices.*, InvoiceDetail.Amount From qInvoices Inner Join On 


Sys(3054,11)