I don't see anything strange here. For each row from the first query you get a copy of each row from the second query.
737 * 809 = 596233 What did you expect would happen? /Oskar 2010/5/5 [email protected] <[email protected]>: > I am new to Stored Procs, so please bear with me guys... but I am > having a strange issue, and thought that I would post it here whilst I > continue to try and sort it out - perhaps someone else has expereinced > it. > > Both the queries below returns the correct results individually: > > SELECT #repeatOrders.repeatresellerID FROM > #repeatOrders.repeatresellerID WHERE #repeatOrders.repeatresellerID = > 1114 > ---737 records returned --- > > SELECT #newtOrders.newsellerID FROM #newtOrders.newsellerID WHERE > #newtOrders.newsellerID = 1114 > ---809 records returned --- > > but when I attempt to combine them, I get a horribly large number of > records returned... The join I am using is listed below: > > SELECT > #repeatOrders.repeatresellerID > FROM > #repeatOrders > INNER JOIN #newOrders on #newOrders.newresellerID = > #repeatOrders.repeatresellerID > WHERE #repeatOrders.repeatresellerID = 1114 > > ---596233 records returned --- > > > Does anyone have any ideas ? > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
