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)