I'm using Aliases
SELECT A.ResortName, B.Year, B.News
FROM Resorts A, NewFor B
WHERE B.ResortID = A.ResortID
ORDER BY B.Year
hehehehe
>From: "Jim McAtee" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT: SQL Query Help
>Date: Mon, 11 Jun 2001 13:16:05 -0600
>
>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
