I guess i dont follow what it is you are trying to accomplish and how the results of that query differs from the results you are trying to get.
please provide more details on the results you are getting versus the results you expect, if you could provide a dump of the table, that would be helpful too.