select * from Table1 where ColCode in (select distinct ColCode from Table2 where CodeNo = 12345678 and Active = 'Y')
var result = from t1 in Table1 where t1.ColCode in (from t2 in Table2 where t2.CodeNo == 12345678 && t2.Active == 'Y' select t2.ColeCode).Distinct() select t1;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)