title: How to join 2 tables without relationship in SQL
body: <p>I am struggling to combine three tables with outer join, but cant get it right
  I am using PostgreSQL database..
  My tables look like this:</p>
  <p><img src="https://i.stack.imgur.com/ulWE0.png" alt="my tables" /></p>
  <p>My Orders table have the foreign key of Customers and Years (this two dont have any relation)
  Some year and Customer are not presented in my Orders table
  I am trying to make an sql query so that each customer have all year. I can get this result by cross join customer and year, but this approach doesn't work when i continue to join this result with other tables. (My Orders table have other foreign keys also that i have to join also) So can i get this result by using outer join instead?</p>
  <p>I have tried:</p>
  <pre><code>Select* From Orders
  RIGHT JOIN Customers on Orders.customer_id = customer.id
  </code></pre>
  <p>That give me all the customer in Orders table (even them who doesent have a order) then i would like to do the same with all years also so every customer have one row for each year(2015-2020) Have tryed to do another right join with years table but it doesent work.. Anyone know how to fix this?</p>
  <p>p.s the names of the tables is not real,i just used this names to make it easier to understand!</p>