Exam 70-761 topic 1 question 195 discussion

answer in another exam says : product left join productproductphoto on product.productid=productproductphoto.productid full outer join productphoto on productproductphoto.productphotoid=productphoto.productphotoid

i saw an exam with the exhibit, but still this question is extremely vague. No idea what they want exactly.

I believe second one should also be right join because ProductPhoto table is in the right part of the query Since we need all rows ProductPhoto then RIGHT JOIN would be appropriate.

There is not HOT AREA in the question . We cannot judge . Because I saw the hot area for the question in another dumps . It has options for the presented code. FROM clause there looks like: FROM Product /Option/ ProductProductPhoto /Opton / ProudctPhoto

The Query is: SELECT ProductPhoto.ProductPhotoID ,Product.ProductID ,ProductProductPhoto.IsPrimary FROM Product Box 1 [LEFT JOIN; RIGHT JOIN; CROSS JOIN; FULL OUTER JOIN] ProductPhoto Box 2 [LEFT JOIN; RIGHT JOIN; CROSS JOIN; FULL OUTER JOIN] ProductProductPhoto ON ProductProductPhoto.ProductPhotoID = ProductPhoto.ProductPhotoID Box 3 [OR; AND; AND NOT] ProductProductPhoto.ProductID=Product.ProductID It says: "You must create a report that returns a list of all product photos" So I beleive we need to bring all the rows for the table ProductPhoto, which I think would be RIGHT JOIN / LEFT JOIN / AND

There is no SQL statement :/

LEFT JOIN / LEFT JOIN ?