wrong result from subquery in WHERE EXISTS

Hi
I have the following tables,
1)category
deptID
2)categoryTree
ancestor
descendant
3)products
productName
deptID
say a category tree as […]

Original post by jojoba

Leave a Reply