You have two tables named Cars and Color as defined below. The two tables are related by ColorId.
You run the following SQL statement: select:
How many rows does the SQL statement return?
A. 0
B. 2
C. 3
D. 6
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
B- is correct answer when you say ID = ID it is main INNER join
answer
left outter join or left join are the same, so that the keyword is outer and outer means everything in the Cartesian diagram, as you can see on the code above cars.colodid = colors.colorid so that’s mean three because we have three rows on the table
Pls can someone explain how the answer was arrived at?