title: How do I query multiple tables using inner join?
body: <p>Given the table creation SQL and insertion SQL, How will I generate a query to display the information in a a particular way?</p>
  
  <pre><code>CREATE TABLE cities (
     id serial NOT NULL UNIQUE PRIMARY KEY,
     iname varchar(100) NOT NULL UNIQUE
  )
  
  CREATE TABLE suburbs (
      id serial NOT NULL UNIQUE PRIMARY KEY,
      icity integer REFERENCES cities (id), 
      iname varchar(100) NOT NULL UNIQUE
  )
  CREATE TABLE type (
     id serial NOT NULL UNIQUE PRIMARY KEY,
     iname varchar(100) NOT NULL UNIQUE
  )
  CREATE TABLE sale (
     id serial NOT NULL UNIQUE PRIMARY KEY,
     iname varchar(100) NOT NULL UNIQUE
  )
  
  CREATE TABLE estate (
      id serial NOT NULL UNIQUE PRIMARY KEY,
      icity integer REFERENCES cities (id),
      isuburb integer REFERENCES suburbs (id),
      itype integer REFERENCES type (id),
      isale integer REFERENCES sale (id),
      idescription text,
      itimestamp timestamp DEFAULT CURRENT_TIMESTAMP
  )
  
  INSERT INTO cities (iname) VALUES ('Johannesburg');
  INSERT INTO suburbs (icity, iname) VALUES (1, 'Westbury');
  INSERT INTO type (iname) VALUES ('Room');
  INSERT INTO sale (iname) VALUES ('Rent');
  
  INSERT INTO estate (icity, isuburb, itype, isale, idescription) VALUES (1, 1, 1, 1, 'A Nice place in a real bad neighbor hood');
  </code></pre>
  
  <p>Now I want the numerical values that are in the table estate to be displayed by the string values that they represent.</p>
  
  <p>E.G
  1 Johannesburg, Westbury, Room, Rent, Description</p>
  
  <p>What will the SQL Query be for this, I am more concerned in using postgreSQL. </p>