Forum Discussion
Poner en un campo la unión de otros dos campos de la misma tabla.
Hola
¿Qué tengo que hacer para poner en un campo de una tabla la unión de otros dos o más campos de la misma tabla?
Gracias
Saludos
No lo haga, por favor.
I have to finish the reply in English. One of the basic rules of Relational Database Design is that each piece of data belongs in a separate field in a table. Whatever data is in those two fields needs to remain in separate fields. Adding a third field combining them would create redundancy. It also creates the risk of data discrepancy if one of the component fields is modified later.
You can combine -- or concatenate -- fields for display only in a query, though.
SELECT Field1 & " " & Field2 as Combined field
FROM YourTableNameGoesHere
