Thank you for informing us,
I will display a stock report by this query, One of the necessary data is counted inventory amount. Counted amount of inventory can be updated at different times. Therefore, to reach the updated counting results of different time periods I use below mentioned subquery.

SHB_ID=(
SELECT FIRST 1 SHB_ID FROM SHRKSTR AS ST1,SHRKBSLK AS ST2,SHRKTNM AS ST3
WHERE SYMSFB.SHB_SDP=ST1.SHB_SDP AND ST1.SHB_SHA=ST2.SHA_ID AND
ST2.SHA_SHT=ST3.SHT_ID AND ST3.SHT_ISLTIPI=4 AND ST2.SHA_SEVKTRH
BETWEEN '01.01.2009' AND '31.12.2009' AND
SYMSFB.SHB_STK=ST1.SHB_STK ORDER BY ST2.SHA_SEVKTRH DESC)


----------------------------------------------------------------------
Re: speed problem

--- In firebird-support@yahoogroups.com, "akdatilla" <akdatilla@...> wrote:
>
> Hi,
> We have a problem about firebird database. The following sql text run in the
sqlserver database for 2-3 seconds. But in the firebird database this sql run
for 25 minutes. How can we run this sql query quickly in the firebird.
> Could you help to us for this problem.
> Best Regards.
>
> Sql:
>

If you replace

SHB_ID=(
SELECT FIRST 1 SHB_ID FROM SHRKSTR AS ST1,SHRKBSLK AS ST2,SHRKTNM AS ST3
WHERE SYMSFB.SHB_SDP=ST1.SHB_SDP AND ST1.SHB_SHA=ST2.SHA_ID AND
ST2.SHA_SHT=ST3.SHT_ID AND ST3.SHT_ISLTIPI=4 AND ST2.SHA_SEVKTRH
BETWEEN '01.01.2009' AND '31.12.2009' AND
SYMSFB.SHB_STK=ST1.SHB_STK ORDER BY ST2.SHA_SEVKTRH DESC)

with

SHB_ID=0 (or SHB_ID = '0')

what do you get ?


Regards,
Zlatko