Select INTO two tables made it with "With"
Dear all,
Is possible to make a Select INTO from Luis2 to Luis in SQL?
WITH Luis AS (
Select
Id_OrdenProduccion,
c.Id
from PartesProduccion pp
LEFT JOIN Cultivos c ON pp.Id_OrdenProduccion =
C.Id
where c.Id = 2027 OR c.Id = 1019),
Luis2 AS (
Select
Id_OrdenProduccion,
c.Id
from PartesProduccion pp
RIGHT JOIN Cultivos c ON pp.Id_OrdenProduccion =
C.Id
where c.Id = 2027 OR c.Id = 1019)
SELECT *
from Luis2