As far as I can see, you're trying to actually select an employee count
by using a join with a 1-M realtionship. How could that be returned with
an exists query?

Either you're not telling us what you actually want, or I'm missing
something.

Kjell

dinol.softedge wrote:

>
>
> Hi
>
> I am trying to optimize the following count query by changing it to an
> exists query. I have tried various exists statements but I cannot
> seem to get it right. Any help would be greatly appreciated
>
> The count subquery is near the bottom
>
> SELECT

[snip irrelevant part]

> (SELECT COUNT(EMPLOYEE_ID) FROM TBL_JOB_CARD_EMPLOYEE WHERE
> TBL_JOB_CARD.JOB_CARD_ID = TBL_JOB_CARD_EMPLOYEE.JOB_CARD_ID) AS
> EMPLOYEE_COUNT,
> TBL_JOB_CARD.AMOUNT_DUE,
> TBL_JOB_CARD.INVOICE_PRICE_INCL,
> TBL_JOB_CARD.VAT
> FROM
> TBL_JOB_CARD
> LEFT OUTER JOIN TBL_CLIENT ON (TBL_JOB_CARD.CLIENT_ID =
> TBL_CLIENT.CLIENT_ID)
> LEFT OUTER JOIN TBL_INSURER ON (TBL_JOB_CARD.INSURER_ID =
> TBL_INSURER.INSURER_ID)
> ORDER BY
> JOB_CARD_ID DESC
>
>

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64