How would you write a left join statement to return a result set of movie.title�s and director.name�s?
- 1 Answers
- 1138 Views
- I also Faced
- E-Mail Answers
Answer Posted / Amrit Kumar
In SQL, the LEFT JOIN keyword returns all records from the left table (movie), and the matched records from the right table (director). If there is no match, the result is NULL on the right side. Here's an example:n```nSELECT movie.title, director.namenFROM movienLEFT JOIN director ON movie.director_id = director.id;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain how to generate iqd file from framework manager?
