At 02:38 AM 26-04-01 +0000, you wrote:

>SELECT ITEMUSED_ID
> , JOBNO
> , ITEMNO
> , QTY
> , CAT1
>FROM ITEMSUSED
>JOIN CATEGORY1 C1 ON C1.CAT1NO=(SELECT CAT1NO FROM ITEMS WHERE
>ITEMS.ITEMNO=ITEMSUSED.ITEMNO)
>
>seems to work fine too! I guess this is the preferred option(?)

steve,
the preferred option is the one that returns the correct data fastest in your own environment. The only way to determine this is to test both strategies with typical numbers of input and output rows. You can do this type of testing quite easily using the sql monitor.

cheers,
helen




All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________