miércoles, 10 de abril de 2019

obtener dos valor en un mismo registro, sql



SELECT x.valor , y.valor FROM (SELECT valor from configuracion t1 where elem='vcto_folios') as x, (SELECT valor from configuracion t2 where elem='vcto_caf') as y


SELECT T1.valor AS [RUT],T2.valor AS [RS]
FROM configuracion T1 LEFT JOIN configuracion T2 ON T2.elem = 'razon_social'
WHERE T1.elem='rut_empresa'



fuente

No hay comentarios.:

Publicar un comentario