I'm working on building an online scheduling system. I want to be able to select all the users who don't have any scheduled commitments on the next weekend and then sort based on when the users next scheduled spot is. I have a few problems however. First of all I have a set of users who don't have any future commitments so they don't show up in a join. In addition in the table that stores time commitments there are 3 users per time commitment. To summarize my table schemes I have 2 tables that are used for this: (I have omitted fields that have nothing to do with this problem)
1. Stores information about people (People) Field Name Type Notes number int(11) Primary id for people name varchar 2. Stores information about scheduled slots (Games) Field Name Type Notes number int (11) Primary id for games date date center int (11) foreign key to people table ar1 int (11) foreign key to people table ar2 int (11) foreign key to people table I want to be able to retrieve something along the lines of name People.number nextcommitmentdate Any ideas how to go about running this query? ---------------- Thanks Jefferson Cowart [EMAIL PROTECTED] Support Open Instant Messaging Protocols http://www.petitiononline.com/openIM/petition.html --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php