How do JOINs really work ?

Hi, I have this (simplified) query :

SELECT (select count(*) from titresupport s2 where s2.idsupport=s.id) as tottitres
FROM castings c
JOIN supports s ON (c.idsupport=s.id)
JOIN ventes v ON (v.idsupport=s.id)
JOIN distributeurs d ON (d.iddistributeur=v.iddistributeur)
LEFT JOIN canauxvente k1 ON (k1.idcontrat=c.idcontrat AND k1.id_pays=v.id_pays AND k1.idtypedistributeur=d.idtypedistributeur)
WHERE c.idcontrat=:idcontrat

But EM/NxServer complain on "unable to resolve the identifier "s"."id"

Now, if I remove the "LEFT JOIN" line it works. Why ?

This is with NXServer 2.0599r2
I post the data to binary.

> Now, if I remove the "LEFT JOIN" line it works. Why ?

Bug. Most likely same/similar to 2255. Issue# 2258

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm

Hannes Danzl[NDD] a écrit :
>> Now, if I remove the "LEFT JOIN" line it works. Why ?
>
> Bug. Most likely same/similar to 2255. Issue# 2258

Thanks.