SQL联接查询与数据功能 [英] sql join query with data function

问题描述

select s.part_no,s.part_name,i.qty as inwardQty,p.qty as issueQty 
from stock s 
left join
    (select part_no,sum(qty) as qty from inward group by part_no) i on s.part_no = i.part_no
left join
    (select part_no,sum(qty) as qty from issue group by part_no) p on s.part_no = p.part_no

在上面的查询中，我希望只显示特定月份的数据
为此，我想在查询中添加这些条件，即 month(i.date)= 6，month(p.date)= 6 .我应该在我的查询中添加此条件.

谢谢您

In the above query ,i want that data should be display only for particular month
For this i want to add these condition in my query i.e month(i.date)=6,month(p.date)=6.whare should i add this condition in my query.

Thank You

推荐答案

您是否可以在下面的查询中检查是否解决了您的问题.

can you check this below queries if it is solve your problem or not.

select s.part_no,s.part_name,i.qty as inwardQty,p.qty as issueQty 
from stock s 
left join
    (select part_no,sum(qty) as qty,date from inward group by part_no) i on s.part_no = i.part_no
left join
    (select part_no,sum(qty) as qty,date from issue group by part_no) p on s.part_no = p.part_no
WHERE month(i.date)=6,month(p.date)=6



select s.part_no,s.part_name,i.qty as inwardQty,p.qty as issueQty 
from stock s 
left join
    (select part_no,sum(qty) as qty from inward WHERE month(i.date)=6 group by part_no) i on s.part_no = i.part_no
left join
    (select part_no,sum(qty) as qty from issue WHERE month(p.date)=6 group by part_no) p on s.part_no = p.part_no

WHERE子句与子查询相关，因此它们仅在子查询中.

试试:

WHERE clauses are relatd to subqueries, hence they will be in sub query only.

Try:

select s.part_no,s.part_name,i.qty as inwardQty,p.qty as issueQty
from stock s
left join
    (select part_no,sum(qty) as qty from inward where month(i.date)=6 group by part_no) i on s.part_no = i.part_no
left join
    (select part_no,sum(qty) as qty from issue where month(p.date)=6 group by part_no) p on s.part_no = p.part_no

这篇关于SQL联接查询与数据功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！