This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: PET_OWNER AS O, PET AS P WHERE O.OwnerID = P.OwnerID AND Breed = Cat AND Name = Teddy; 3.40 SELECT Name, Email FROM PET_OWNER AS O LEFT JOIN PET AS P ON O.OwnerID = P.OwnerID WHERE Breed = Cat; It differs from question 3.37 because the left join syntax will not leave out one of the values that does not match the OwnerID in the Breed table. In 3.40 it will post or append rows of PET_OWNER to PET even if any row in the table on the left side of the FROM clause has no match or is blank....
View Full Document
This note was uploaded on 04/13/2008 for the course INFO 328 taught by Professor Norton during the Spring '08 term at Texas A&M.
- Spring '08