title: SQL: How to join two tables to get names instead Id's to search engine using LIKE?
body: <p>I have two tables named: t_servicio and cat_clientes and are composed as follows:</p>
  
  <p><strong>t_servicio:</strong>
  <img src="https://i.stack.imgur.com/qIwK5.png" alt="t_servicio"></p>
  
  <p><strong>cat_clientes:</strong>
  <img src="https://i.stack.imgur.com/QgDxH.png" alt="cat_clientes"></p>
  
  <p>Table t_servicio hosts the "Id_Cliente". So I'm doing is a search engine in many columns for now I just want to search the <strong>"Id_cliente"</strong> column. the question is, how I can get the names of customers (clientes) joining the table <strong>t_servicio</strong> with the table <strong>cat_clientes</strong> using the LIKE condition to find matches?</p>
  
  <p>I hope can help me please!</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>And for example, when getting the results, the columns <strong>Marca, Producto y SubProducto</strong> only shows the ID but I want her names and, what would be the sentence?</p>
  
  <p>I want result like this:
  <img src="https://i.stack.imgur.com/kZQIp.png" alt="result like this"></p>