>I have the following tables:
>
>1. Customers.Customerid (inner join) Products.Customerid
>2. Customers.Addressid (inner join) Address.Addressid
>3. Customers.Customerid (inner join) invoices.invoiceid
>4. Invoices.Invoiceid (inner join) invdetail.invoiceid
>
>I would like to create a cursor where "Invoice.cTypd = 'EST'"

---

select * ;
 from FORCE Customers a ;
    inner join Products b on a.CustomerId = b.CustomerId ;
    inner join Address c on a.AddressId = c.AddressId ;
    inner join Invoices d on a.CustomerId = d.CustomerId ;
    inner join Invdetail e on d.InvoiceId = e.InvoiceId ;
 where d.cTypd = 'EST' ;
 into cursor myCursor

2. Customers.Addressid (inner join) Address.Addressid
3. Customers.Customerid (inner join) invoices.invoiceid
questionable on connecting expressions (of course might be exactly like that).
Cetin