join | SourceCodester

SQL JOINs Explained with Examples: INNER, LEFT, RIGHT, FULL OUTER and SELF JOIN in MySQL

Submitted by jaypabs on Sun, 11/01/2026 - 09:18

If you have ever stored data in more than one table, you have run into this question: how do I show the student's name together with the course name when they live in different tables? The answer is a JOIN. JOINs are one of the most used features of SQL, they show up in almost every capstone project, and they are a favorite topic in technical interviews.

Read more about SQL JOINs Explained with Examples: INNER, LEFT, RIGHT, FULL OUTER and SELF JOIN in MySQL
Log in or register to post comments
11 views

How to Split and Join a String in Python

Submitted by razormist on Sat, 11/02/2024 - 12:29

In this tutorial, we will program "How to Split and Join a String in the Console Terminal using Python." We’ll focus on splitting a string into segments and then rejoining it with a specified character or string. The objective is to split a given string safely and then join it with an additional character or separator to form a new string. A sample program will be provided to demonstrate the coding process.

Read more about How to Split and Join a String in Python
Log in or register to post comments
199 views

Combining Two Tables of SQLite3 Database in PHP Tutorial

Submitted by razormist on Fri, 08/27/2021 - 16:50

Learn on how to create a Combine Two Tables In SQLite3 using PHP. An advanced PHP coding technique that uses SQLite database to combine two tables. This is a useful trick when you want to combine two tables into a single readable table format from the SQLite database.

Read more about Combining Two Tables of SQLite3 Database in PHP Tutorial
Log in or register to post comments
1227 views

PHP - Simple Join Table Using MySQLi

Submitted by razormist on Fri, 04/26/2019 - 08:23

Learn on how to create a Simple Join Table Table using MySQLi. An advance php approach that ca joint two tables in the database server. This is a useful tips for displaying a two table that has been merge into a single table.

Read more about PHP - Simple Join Table Using MySQLi
Log in or register to post comments
460 views

Laravel: Joining Tables

Submitted by nurhodelta_17 on Fri, 11/24/2017 - 20:14

This tutorial tackles on how to join two or more tables in Laravel at the same time showing the results of this join. In PHP, we have several join method whereas in Laravel, we only use one method which is join(). In this tutorial, I'm going to join three tables.