And for the really nerdy table the only option would have been a Self Join :D
Milind. From: [email protected] [mailto:[email protected]] On Behalf Of Ken Auenson, II Sent: Tuesday, March 30, 2010 10:22 PM To: [email protected] Subject: Re: [houcfug] Nerd Humor maybe, but a cross join might lead to more interesting results... --Ken On Tue, Mar 30, 2010 at 10:12 PM, Aaron Rouse <[email protected]<mailto:[email protected]>> wrote: So we might be talking out an outer join here? On Tue, Mar 30, 2010 at 9:02 PM, Eddie Pequeno <[email protected]<mailto:[email protected]>> wrote: Well if the guy got lucky it is a one to one relationship. If he reeeeeeely got lucky then it's a one to many relationship. -Eddie --- On Tue, 3/30/10, Aaron Rouse <[email protected]<mailto:[email protected]>> wrote: From: Aaron Rouse <[email protected]<mailto:[email protected]>> Subject: Re: [houcfug] Nerd Humor To: [email protected]<mailto:[email protected]> Date: Tuesday, March 30, 2010, 8:40 PM I don't quite understand it, what type of relationship did the tables have? On Tue, Mar 30, 2010 at 8:23 PM, Mark Davis <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> wrote: Okay...that made me laugh out loud. I am a nerd -----Original Message----- From: Seth Bienek <[email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]>> Sent: March 30, 2010 8:13 PM To: [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> Subject: [houcfug] Nerd Humor So this SQL query walks up to two tables at a bar and says, "Mind if I join you?" -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en To unsubscribe, reply using "remove me" as the subject. -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<http://us.mc536.mail.yahoo.com/mc/[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en -- Aaron Rouse http://www.happyhacker.com/ -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en -- Aaron Rouse http://www.happyhacker.com/ -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en
