On Sun, Feb 12, 2006 at 08:03:07AM -0800, Bill Moseley wrote:
> BTW -- Is there a way to turn something like this into a view? The
> 2 domain bind parameters will alway match, and the only other
> input parameters are the two review mode booleans. That is, the
> input to the query is a domain id,
On Sat, Feb 11, 2006 at 12:35:34AM -0700, Michael Fuhr wrote:
> On Fri, Feb 10, 2006 at 11:59:30AM -0800, Bill Moseley wrote:
> > How do I make a join on the class table but not effect the left outer
> > join?
>
> Are you looking for something like this?
>
> LEFT OUTER JOIN (class INNER JOIN clas
On Fri, Feb 10, 2006 at 11:59:30AM -0800, Bill Moseley wrote:
> How do I make a join on the class table but not effect the left outer
> join?
Are you looking for something like this?
LEFT OUTER JOIN (class INNER JOIN class_domain ON ...) c ON ...
--
Michael Fuhr
---(end
I've been staring at this too long. Could someone give me a bit of
sql help?
I want to show a list of upcoming workshops, and the number of
sessions (classes) offered for each workshop:
workshop_id | classes_offered | review_mode | workshop_cat
-+-+-
