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:198681 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
