add in the end group by <-- fields other than sum or count that appears
after select base word -->

>
> SELECT DISTINCT KORTER,ULDPIND FROM KORTERID,EIMAKSA WHERE ID=KORTER AND
> MAJA='Kurni 34' AND ID NOT IN(SELECT KORTER FROM EIMAKSA WHERE KULU=5).
> (or something like that, I wrote it now from memory)
> ... but I couldn't create SUM(ULDPIND).
> Is it possible? Are there any kind better exclusive joins where I can select
> everything from one table that do not exist in another table
>
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>