Thanks!
I had to made some changes (use left join and reorder some criterias),
but now it seems to work OK.

SELECT for_pay.id
,a.account as accountno
, ACCID
.....
, c.REGNO
FROM for_pay c
left join v_account a on a.id=c.accid and c.docdate between a.sdate and
a.edate
where
uid=:UID and install=:INST


Riho Ellermaa




_____

From: Helen Borrie [mailto:helebor@...]
Sent: Monday, March 15, 2004 11:03 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Sorting problem


Riho-Rene,
It's not just a sorting problem, it's a general SQL syntax
problem.


SELECT
a.account,
c.id,
c.bank,
c.accid,
c.status,
c.ibank,
c.currency
from v_account a
join for_pay c
on a.id = c.accid
where
c.docdate between a.sdate and a.edate
and c.uid = :UID
and c.install = :INST


Helen






[Non-text portions of this message have been removed]