You need to give us more information. First and foremost, you didn’t even ask a question. But, how do the tables relate? Why are you not using ansi style joins? Is that "result set" the result you are receiving or the one you want? Perhaps some sample data to illustrate the issue?