General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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:(
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only