Strange left join behaviour

[Philippe Chaleat]

Hello,
Is there a way to explain this
QUERY 1 :
select count(*) 
FROM VT_CdeLig CdeLig
LEFT OUTER JOIN VT_Article Article
 ON CdeLig.noArt = Article.ik AND Article.noDosRes = 1
LEFT OUTER JOIN VT_Commande Commande
 ON CdeLig.noCde = Commande.ik AND Commande.noDosRes = 1
WHERE Commande.datDepart    >=    '2005-04-17'  AND Commande.datDepart 
<=  '2005-04-19' and CdeLig.noDosRes = 1 

Result : 209
QUERY 2 (just change the order of the left join in QUERY 1)
select count(*) 
FROM VT_CdeLig CdeLig
LEFT OUTER JOIN VT_Commande Commande
 ON CdeLig.noCde = Commande.ik AND Commande.noDosRes = 1
LEFT OUTER JOIN VT_Article Article
 ON CdeLig.noArt = Article.ik AND Article.noDosRes = 1
WHERE Commande.datDepart    >=    '2005-04-17'  AND Commande.datDepart 
<=  '2005-04-19' and CdeLig.noDosRes = 1 

Result : 29
QUERY 3 : (QUERY 1 withtout a condition in the first ON clause)
select count(*) 
FROM VT_CdeLig CdeLig
LEFT OUTER JOIN VT_Article Article
 ON CdeLig.noArt = Article.ik
LEFT OUTER JOIN VT_Commande Commande
 ON CdeLig.noCde = Commande.ik AND Commande.noDosRes = 1
WHERE Commande.datDepart    >=    '2005-04-17'  AND Commande.datDepart 
<=  '2005-04-19' and CdeLig.noDosRes = 1 

Result : 29
Any idea ?
SAPDB version: 7.4.3.32 - Build: 032-123-068-842

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]