<div>
<br />
ok but what about the rest of the part of query, ?<br />
just leave as it is and put where condition on Rtr_Stock_Dtl <br />

</div>



ok but what about the rest of the part of query, ?
just leave as it is and put where condition on Rtr_Stock_Dtl


<div>
<div class="content wysiwyg-content">
Hi <br />
i got this query from mlmcc, its working like charm.<br />
after some times requirement is changed and <br />
i want to add some more condition in this same query.<br />
like in this part of query &nbsp;i want sum(CFC), sum(PCS), Sum(Total_PCS) where Saleable = Salable<br />
but rest of the thing as it is i want.<br />
<br />
&quot;Union Select Prd_Code, Prd_Name, Category, sum(CFC), sum(PCS), Sum(Total_PCS), 0 as D_Rtr_CFC, 0 as D_Rtr_PCS, 'RtrStock' as Source From Rtr_Stock_Dtl group by Prd_Code, Prd_Name, Category &quot;&nbsp;&amp; _<br />

</div>
</div>


Hi 
i got this query from mlmcc, its working like charm.
after some times requirement is changed and 
i want to add some more condition in this same query.
like in this part of query  i want sum(CFC), sum(PCS), Sum(Total_PCS) where Saleable = Salable
but rest of the thing as it is i want.

"Union Select Prd_Code, Prd_Name, Category, sum(CFC), sum(PCS), Sum(Total_PCS), 0 as D_Rtr_CFC, 0 as D_Rtr_PCS, 'RtrStock' as Source From Rtr_Stock_Dtl group by Prd_Code, Prd_Name, Category " & _


MS Query (Union Query)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.