Hi,

At September 9, 2004, 06:03, Martijn Tonies wrote:

> Hi,

>> >select
>> >c.name, c.surname, c.telephone, c.lastorderdate
>> >from customers c
>> >where NOT EXISTS (
>> > select customerlink from orders
>> > where
>> > recdate > '01-jan-2004' and
>> > recdate < '01-feb-2004' and
>> > branchcode = 'SAN'

> Does adding this help:
> and orders.customerlink = c.link

That would give the same that I posted.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)