I suppose what you expected and what others expect is a little different. Just because you used the two id's in a join in a SQL select doesn't mean that either should appear in the output!

The behaviour of DBD is quite well documented, their are plenty of tutorials around, even within the Monastery, and some excellent books that deal with all of the concepts.

What you are saying is that in your view the behaviour of DBD in this instance is counter-intuitive whilst to those of us who live with DBI/DBD every day it is quite the expected behaviour and their are several ways of dealing with the issue once you are aware of it.

jdtoronto