我怎样才能实现这种类型的选择查询? [英] How can i achieve this type of select query ?
问题描述
我有两张桌子
MPL_DET(JobNo(pk),SystName,ReqQty)
MPL_ITDET(ID(pk),JobNo(FK),IT_Name,QtyPSys,IssQty)
我想从MPL_DET中选择JobNo其中
MPL_ITDET.IssQty< MPL_ITDET.QtyPSys * MPL_DET.ReqQty
(问题是MPL_DET.ReqQty会给出多个记录
但我希望记录属于特定的JobNo )
对不起,如果我的问题不清楚!
试试这个
SELECT JobNo 来自 MPL_DET MD INNER JOIN MPL_ITDET MID ON MD.JobNo = MID.JobNo
WHERE MID.IssQty< (MID.QtyPSys * MD.ReqQty)
尝试:SELECT d.JobNo FROM MPL_ITEDT i
JOIN MPL_DET d
ON i.JobNo = d.JobNo
WHERE i.IssQty< (i.QtyPsys * d.ReqQty)
回滚其他的多余更改 - OriginalGriff [/ edit]
I have two tables
MPL_DET(JobNo(pk), SystName, ReqQty )
MPL_ITDET( ID(pk), JobNo(FK), IT_Name, QtyPSys, IssQty)
I want to select the JobNo from MPL_DET where
MPL_ITDET.IssQty < MPL_ITDET.QtyPSys * MPL_DET.ReqQty
(Problem is MPL_DET.ReqQty will give multiple records
but i want the record belongs to perticular JobNo)
Sorry if my question is not clear!
try this
SELECT JobNo from MPL_DET MD INNER JOIN MPL_ITDET MID ON MD.JobNo = MID.JobNo WHERE MID.IssQty < ( MID.QtyPSys * MD.ReqQty )
Try:SELECT d.JobNo FROM MPL_ITEDT i JOIN MPL_DET d ON i.JobNo=d.JobNo WHERE i.IssQty < (i.QtyPsys * d.ReqQty)
[edit]Rolled back superfluous changes made by other - OriginalGriff[/edit]
这篇关于我怎样才能实现这种类型的选择查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!