Would this work or am I missing a piece of the puzzle?
Select *
>From lessons
Left join lessons on lessons.lessonID = students.lessonID
Where students.studentID = #studentID#
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-----Original Message-----
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 1:42 PM
To: CF-Talk
Subject: SQL Join Challenge
I have run across a problem for which I think a SQL solution should
exist.
I essentially need to do a left-join on two columns.
I need to get every row from one table (say "lessons") and any rows from
another (say "students") for which the LessonID columns of each table
match AND where the StudentID of the "students" table matches a given
value. I cannot find a way to get this result set and still have one and
only one row for each record in the "lessons" table.
I would google for this, but I don't even know what to search for.
Anyone have any ideas?
Thanks!
Steve Bryant.
Bryant Web Consulting LLC
http://www.BryantWebConsulting.com
http://steve.coldfusionjournal.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198684
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
