PostgreSQL INNER JOINS
Inner joins are a way to combine two tables, one on the left and one on the right, and then perform an operation between those two tables. The first table is called the left table, and it has all the data you want to compare with your right table. The second table is called the right table, and it has all of the data that you want to compare with your left table.
The syntax for an inner join is as follows:
SELECT [column_list] FROM [table1] LEFT JOIN [table2] ON [table1.]column_list = [table2.]column_list;
FOLLOW ME ON:
🐦 Twitter: / bretton73441979
👀 LinkedIn: / gitonga-b. .
📷 Instagram: / brettontelvin
👨💻 GitHub Projects: https://github.com/bretton7700