Re: [SQL] Random sort with distinct

2010-10-04 Thread Ozer, Pam
What about dynamic queries? From: [email protected] [mailto:[email protected]] On Behalf Of Dmitriy Igrishin Sent: Saturday, October 02, 2010 6:40 AM To: Ozer, Pam Cc: [email protected] Subject: Re: [SQL] Random sort with distinct Hey Ozer, How about dynam

Re: [SQL] join returns too many results...

2010-10-04 Thread Joshua Tolley
On Sun, Oct 03, 2010 at 02:54:41PM -0400, Frank Bax wrote: > Whatever clause I choose to add I *must* ensure that final result set > contains only one-to-one join between tables. Either of these two > results is acceptable: > > For option 1; result C=All or C=Centre is acceptable. > For option