I could use a bit of help with what I'm guessing is a fairly easy query.
I've got the following:
Tables:
Resorts
NewFor
Resorts Table:
ResortID pk
ResortName
NewFor Table:
NewForID pk
ResortID fk
Year
News
In the NewFor table I've got news for 1999, 2000, 2001, etc. for most (but
not all resorts). I want to return rows for all resorts, along with any
news there may be for the current year.
So the output would be:
ResortName, News (for only 2001, which may be null)
If I do a join, generally I'm left with only resorts which have news records
for the current year, which isn't what I'm after.
Thanks for any assistance,
Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
