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
- Spring '08
- Email PET_OWNER, Email PET_OWNER Type