>SELECT Client.Numero, Province.Numero AS Province_Numero > FROM Client OUTER APPLY (SELECT Province.Numero FROM Province WHERE Province.Numero=Client.NoProvince AND Province.Active=1) Province > >SELECT Client.Numero, > (SELECT Province.Numero FROM Province WHERE Province.Numero=Client.NoProvince AND Province.Active=1) AS Province_Numero > FROM Client > >Thanks, this works.