The .gif is incorrect in lesson four is incorrect in my opinion

Web Development Back-End
1

The .gif is incorrect; it shows only one C2 column resulting from joining the two tables. The query result should repeat the column specified in the ON statement like the environment in image two.

image

I am in lesson 4, module 4 SQL course.

2

Hi,
It depends what columns you use with your SELECT.
so, for instance,

SELECT table1.c1, table1.c2, table2.c3
FROM table1
JOIN table2
    ON table1.c1 = table2.c1;

would give you just the three columns.

So, you’re both right.

Hope that helps

2 Likes