SELECT New.NoMember2 AS Numero FROM New WHERE New.NoMember2>0; UNION; SELECT New.NoMember3 AS Numero FROM New WHERE New.NoMember3>0 GROUP BY 1;But, if this is in a sub query, I obtain "Union in subquery is invalid".
SELECT Member.FirstName FROM Member; WHERE Member.Numero IN (SELECT New.NoMember2 AS Numero FROM New WHERE New.NoMember2>0; UNION; SELECT New.NoMember3 AS Numero FROM New WHERE New.NoMember3>0 GROUP BY 1);
