0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

CREATE TABLE #FECHA(fecha VARCHAR(30))
 
 INSERT INTO #FECHA

 SELECT  '1111'
 UNION ALL     
 SELECT   '2222'   
 UNION ALL     
 SELECT   '3333'   
 UNION ALL     
 SELECT   '4444' 
 UNION ALL     
 SELECT   '5555' 
 
 
CREATE TABLE #ACCESO( name VARCHAR(30),fecha VARCHAR(30))
 
 INSERT INTO #ACCESO        
SELECT    'S1'    ,     '1111' 
UNION ALL
SELECT    'S1'    ,     '2222'
UNION ALL
SELECT    'S1'    ,     '3333'
UNION ALL
SELECT    'S1'    ,     '4444'
UNION ALL
SELECT    'S2'    ,     '1111'
UNION ALL
SELECT    'S2'    ,     '2222'


SELECT A.name,F.fecha	
FROM #ACCESO A
RIGHT JOIN #FECHA F on (F.fecha = A.fecha)

fork query

edited dec 13 17 anonymous

created apr 22 15 Sarath Avanavu