Howdy!
Here's the situation: I've got a table of events, Events, and a table of
categories, Cats. Each event can be in several categories so I have a
third table (EventsXCats) joining Events and Cats. I want to create a form
to admin this system and would like to dynamically present the
categories. I can handle the presentation and processing of the fields but
I'm having difficulty with displaying existing data for edit.
What I want to do is an Outer Join so I get all of the categories and
additional data if the event in question is in a particular category. So I
tried this:
SELECT a.CatName, b.EventID
FROM Cats a LEFT OUTER JOIN EventsXCats b
ON a.CatID = b.CatID
WHERE b.EventID = 123
What I expected:
EventName EventID
------------------ -----------
Concert 123
Exhibition 123
Seminar null
What I got:
EventName EventID
------------------ -----------
Concert 123
Exhibition 123
Can you combine an Outer Join with WHERE criteria? I guess I thought that
was possible. If its not possible, how have others resolved this same problem?
Kevin
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.