I have two tables
t1
:
+--------------+-------------+--------------+
| Product Name | Issue # | Risk Level |
+--------------+-------------+--------------+
| Product1 | Incident#45 | Risk Level 2 |
| Product2 | Incident#23 | Risk Level 3 |
| Product3 | Incident#98 | Risk Level 1 |
+--------------+-------------+--------------+
t2
:
+----------+----------------+
| Org Code | Monthly Output |
+----------+----------------+
| 598 | 2000 |
| 412 | 100 |
| 598 | 2500 |
+----------+----------------+
Which I would like to combine as an "outer join" to create:
+--------------+-------------+--------------+----------+----------------+
| Product Name | Issue # | Risk Level | Org Code | Monthly Output |
+--------------+-------------+--------------+----------+----------------+
| Product1 | Incident#45 | Risk Level 2 | (null) | (null) |
| Product2 | Incident#23 | Risk Level 3 | (null) | (null) |
| Product3 | Incident#98 | Risk Level 1 | (null) | (null) |
| (null) | (null) | (null) | 598 | 2000 |
| (null) | (null) | (null) | 412 | 100 |
| (null) | (null) | (null) | 598 | 2500 |
+--------------+-------------+--------------+----------+----------------+
t1
and t2
have no similar columns for me to join on. Is there any way to join these tables together?
You can use:
select l1.*, l2.*
from l1 full join
l2
on 1 = 0; -- never true