Adding Right Join, Full Join, and Join Visualization Tool

[mostafizur67]

Hi,

I thoroughly enjoyed the lesson on left join and inner join. It provided a clear understanding of these concepts. However, I would love to see the right join and full join covered in the lesson as well.

https://datacarpentry.org/sql-ecology-lesson/03-sql-joins.html

I believe including these topics, along with practical examples, would enhance our understanding of SQL joins comprehensively.

I understand that adding additional join types may extend the lesson beyond its intended scope. If that is the case, I suggest providing supplementary resources or links where participants can explore right join, and full join independently, should they feel interested in delving deeper into these topics.

In addition to this, if you want you can add this visualization tool (https://sql-joins.leopard.in.ua/) to get a visual explanation of different joins.

Thank you for your efforts in delivering this valuable lesson, and I appreciate your consideration.

[adamancer]

Thanks for the suggestion! I agree that including RIGHT and OUTER JOIN would be a useful addition. If this is something you'd be interested in pursuing, please consider creating a pull request with the new information.

As a matter of historical interest, one reason these two types of joins were omitted originally is because SQLite only added support for them last year. I didn't realize this functionality had been added until I was looking into this issue.

The visualizer is a nice tool but I wonder if it provides a significant advantage over diagrams? Any thoughts, @jd-foster?

[mostafizur67]

Hi Adam,

Thanks for your detailed comment and explanations. Sure, once I get some time, I will pull and try to add new information.

[meghalgandhi1019]

Hello,

This is Meghal Gandhi from Carpentry community. I'd like to work on this issue as I have an expertise in SQL.

[jd-foster]

@meghalgandhi1019 Hello Meghal. Thank you for your offer of help. As Adam said above, if this is something you'd be interested in pursuing, please consider creating a pull request with the new information. I think the best thing would be to first post here to start discussing some of your ideas.