Ah....I kinda assumed it would have it! ;-p
-----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 10 July 2006 11:56 To: SQL Subject: Re: How would I go about doing this in a SP? On 7/10/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Yep, inner join as I outlined (just without INNER JOIN syntax) > > I think the reason yours was resolving to a cross join for him was that it didn't have a WHERE clause to define the join condition...in effect making it a cross join. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:6/messageid:2505 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
