I have two tables in the mssql database: orders and batches. Each order can have many lots. The cost is kept in each lot. I would like to draw all orders, where the cost of EACH of his lot is higher than eg 100. If in any part of the order the cost is not greater than 100, this will disqualify the order. Is it possible to do so in one query?I have two tables in the mssql database: orders