COLUMN A COLUMN B COLUMN C 123 4 XXX 124 2 XYZ 125 4 LSK 142 4 TSY 156 2 ASA
COLUMNA COLUMNC COLUMNF COLUMNZ 123 XXX 0 QWRT 124 XYZ 0 TYET 125 LSK 0 REXG 142 TSY 0 LKOY 156 ASA 0 MJKL
table 1 => query1=> select column a where columnb=4
table 2 => select a where columnf=0 and contains (query1)
var result = table2.Where(second=>second.columnf == 0 && table1.Any(first=>first.columnb == 4 && first.columna == second.columna)) .ToList();
&& first.columnc == second.columnc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)