How do you join two tables without a relationship?

Question

One way to join two tables without a common column is to use an obsolete syntax for joining tables. With this syntax, we simply list the tables that we want to join in the FROM clause then use a WHERE clause to add joining conditions if necessary. 6 авг. 2020 г.

What do you need to join two tables?

To apply join between two tables, one table must contain a column that is a reference for the other table. In the example above, the Employees table must have a column that contain a reference key for the department (ex: Department id). As mentioned above, there are multiple approaches to SQL join multiple tables.

How do I join two tables in a table?

Multi-Table JOIN syntax.1FROM table-name1.2JOIN table-name2 ON column-name1 = column-name2.3JOIN table-name3 ON column-name3 = column-name4.4JOIN table-name4 ON column-name5 = column-name6.5...6WHERE condition.

Can we join two tables without common column?

There are few ways to combine the two tables without a common column including Cross Join (Cartesian Product) and UNION. This is not a join but can be useful for merging tables in SQL.

Expert · Answer