yes, except only return one value sum(quantity), since your already returning the partnum in the main query. It's probably not the fastest way, but it might be the easiest way. > To: sql@houseoffusion.com > Subject: Re: Combining Queries > Date: Wed, 8 Feb 2012 15:00:54 -0500 > From: adgpa...@iupui.edu > > > > Can you make it a subquery? select p.partnum, (select partnum, > > sum(quantity) as recqty......), cast(p.part........ G > > I don't know any different to say yes or no. If I do this, do I simply > include the additional select statement in parenthesis? > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3444 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
