阅读背景:

How do you download orders where all batches will meet the condition?

来源:互联网 

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




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: