title: MySQL SELECTs how to join
body: <p>I have these tables on a MySQL Database:</p>
  <pre><code>CREATE TABLE Restaurante(
      nombreRest VARCHAR(30) NOT NULL, 
      telefono INT(9) NOT NULL, 
      domicilio VARCHAR(50) NOT NULL,
      nTenedores ENUM('1','2','3','4','5') NOT NULL,
      tipoCocina VARCHAR(15) NOT NULL,
      nombreCiudad VARCHAR(30) NOT NULL,
      idRestaurante SMALLINT NOT NULL,
      PRIMARY KEY (idRestaurante),
      FOREIGN KEY (tipoCocina) REFERENCES tipoCocina(tipoCocina),
      FOREIGN KEY (nombreCiudad) REFERENCES Ciudad(nombreCiudad)
  )
  
  CREATE TABLE Servicio(
      idServicio SMALLINT NOT NULL, 
      precioT DOUBLE(2,2) NOT NULL, 
      franjaServicio VARCHAR(10) NOT NULL,
      cafe BOOLEAN,
      beINbida BOOLEAN,
      fecha DATE NOT NULL,
      idRestaurante SMALLINT NOT NULL,
      PRIMARY KEY (idServicio),
      FOREIGN KEY (idRestaurante) REFERENCES Restaurante(idRestaurante)
  )
  
  CREATE TABLE Plato(
      nombrePlato VARCHAR(30) NOT NULL,
      descripción VARCHAR(150) NOT NULL,
      idRestaurante SMALLINT NOT NULL,
      PRIMARY KEY (nombrePlato),
      FOREIGN KEY (idRestaurante) REFERENCES Restaurante(idRestaurante)
  )
  
  CREATE TABLE Menu(
      idServicio SMALLINT NOT NULL, 
      PrimerPlato VARCHAR(30) NOT NULL,
      SegundoPlato VARCHAR(30) NOT NULL,
      Postre VARCHAR(30) NOT NULL,
      FOREIGN KEY (idServicio) REFERENCES Servicio(idServicio),
      FOREIGN KEY (PrimerPlato) REFERENCES Plato(nombrePlato),
      FOREIGN KEY (SegundoPlato) REFERENCES Plato(nombrePlato),
      FOREIGN KEY (Postre) REFERENCES Plato(nombrePlato),
      PRIMARY KEY (idServicio)
  
  )
  </code></pre>
  <p>(don't know if they're good, just taking my first course on DB, any suggestions would be appreciated)</p>
  <p>I need to show the list of nombreRest, telefono, domicilio of a Restaurant where they have a menu with these three plato ('Arros Brut', 'Porcella', 'Pijama').</p>
  <p>I've made three diferent selects and my idea is to find a way to join them somehow but i dont know how that would work.</p>
  <pre><code>SELECT idServicio
  FROM Menu
  WHERE PrimerPlato = 'Arros Brut' AND SegundoPlato = 'Porcella' AND Postre = 'Pijama'
  
  SELECT idRestaurante 
  FROM Servicio
  WHERE Servicio.idRestaurante = idServicio
  
  SELECT (nombreRest, telefono, domicilio)
  FROM Restaurante
  WHERE Restaurante.idRestaurante = idRestaurante
  </code></pre>