>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