I have two tables.
One called ‘datospaciente’ and another called ‘inventario’
datospaciente has multiple columns 10 fields: material1, material2 to … material10
This field has one code for equipment (values such as 123, 321..).
enter image description here
Inventario has 2 fields: ‘Codigo’ (for example 123, 321) and ‘Descripcion’.
enter image description here
How can I match the 10 columns to show the correct descripcion
I would like to show in one query: material1 = description1, material2=description2..
Thanks in advance..
Inner join SQL sentence
Federico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.