>> people.person_id > hahahahahhahahhahhhahhhhahaha.....ahhhhh. sigh. > > sorry Chris, back to the topic.
<:| uh? I love it when I'm funny but it's a bit disconcerting when I don't know why. >> it only gets TASKS that belong to the PROJECT that the PERSON > is cleared for > > Im not sure how you are defining "cleared for", but it should just be a > couple more Inner Joins? Well i have a Session.person_id. I should be able to compare that somehow with the table people_project (which is a combination of person_id and project_id), and thereby find out which project(_id)(s) match which the logged in person(_id), right? Thanks! CK. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201382 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