How to make several queries with the same fields but different data in the tables?

Question

How to make several queries with the same fields but different data in the tables?

Navigation

#1 by (2 votes)

2

I would like to join two tables with the same fields but they have leaders loaded in their tables. example

select folio,'ALUMNO' AS ent_sal, observaciones 
from ALUMNO 
where activo='0'

Y

select folio,'MATERIA' as ent_sal, observaciones 
from MATERIA 
where activo='0'

Want it to appear on a single table If someone please.

sql-server

asked by AraceLi Torres 08.08.2016 в 16:05

source

1 answer

Function overload in C ++ passing arguments by value or by reference (Function Overloading) How can I save the result of a query in an array using the MySQL stored procedure?

score 2 · Accepted Answer

Does it give me the impression that you want to have a single result? In that case, you only need to use UNION ALL :

SELECT folio,
       'ALUMNO' ent_sal,
       observaciones
FROM ALUMNO
WHERE activo = '0'
UNION ALL
SELECT folio,
       'MATERIA' ent_sal,
       observaciones
FROM MATERIA
WHERE activo = '0';

Now, if you want to save that result in a new table you can use INTO :

SELECT folio,
       'ALUMNO' ent_sal,
       observaciones
INTO dbo.NuevaTabla
FROM ALUMNO
WHERE activo = '0'
UNION ALL
SELECT folio,
       'MATERIA' ent_sal,
       observaciones
FROM MATERIA
WHERE activo = '0';