select * from table1 inner join table2 on table1.id =table2.id where cash in(select min(cash) from table2)
SELECT t1.id,MIN(t2.cash) as [minCash] FROM tbl1 t1 INNER JOIN tbl2 t2 ON t1.id = t2.id GROUP BY ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)