Right and left join only specify wich table you want all records from. These 2 SELECT are equivalent:
- SELECT * FROM Master LEFT OUTER JOIN Child ON Master.Key = Child.Key
- SELECT * FROM Child RIGHT OUTER JOIN Master ON Master.Key = Child.Key

HTH

>Actually, I understand what you're saying, but if I'm getting SQL correct on a join the circles aren't always parent on left, child on right, instead, a left join says that parent is on left, a right join says that the parent is on right...but I tried both right and left joins and I still don't get what I'm looking for:(