title: SQL Join 2 tables
body: <p>I have two tables one named <code>Person</code>, which contains columns <code>ID</code> and <code>Name</code> and the second one, named <code>Relation</code>, which contains two columns, each of which contains an <code>ID</code> of a <code>Person</code>. It's about a relation between customer and serviceman. I'd like to Join these two tables so that I'll have names of people in every relation. Is it possible to write this query with some kind of joining?</p>
  
  <p>EDIT::</p>
  
  <p>I must do something wrong, but it's not working. I had tried a lot of forms of so looking queries, but I had been only getting one column or some errors. It's actually the school task, I have it already done (with different JOIN query). Firstly I had been trying to do this, but I'd failed: It seems to be very common situation, so I don't know why it's too complicated for me..</p>
  
  <p>Here are my tables:</p>
  
  <pre><code>CREATE TABLE Oprava..(Repair) (  
    KodPodvozku INTEGER PRIMARY KEY REFERENCES Automobil(KodPodvozku),  
    IDzakaznika..(IDcustomer) INTEGER REFERENCES Osoba(ID),  
    IDzamestnance..(IDemployee) INTEGER REFERENCES Osoba(ID)  
  );
  
  CREATE TABLE Osoba..(Person) (  
    ID INTEGER CONSTRAINT primaryKeyOsoba PRIMARY KEY ,  
    Jmeno..(Name) VARCHAR(256) NOT NULL,  
    OP INTEGER UNIQUE NOT NULL  
  );
  </code></pre>
  
  <p>It's in Czech, but the words in brackets after ".." are english equivalents.
  PS: I am using Oracle SQL.</p>