Re: NULL values in a SELECT in another SELECT


SELECT x, y
FROM Foo AS F
  CROSS APPLY (SELECT y FROM Bar AS B1 WHERE B1.x = F.x
                      UNION
                      SELECT y FROM Bar AS B2 WHERE B2.x = F.x) AS B
WHERE y IS NOT NULL;

Yeah, that's it !
But I'm under SQL Server 2000.... I think I'll keep the first
solution.

S. Rielau : the problem is the "WHERE B1.x=F.x".
If I write SELECT X FROM F, (SELECT ... FROM B1 WHERE B1.x=F.x) AS F1
SQL Server doesn't recognize F.x.
.