In message <[EMAIL PROTECTED]>, John R. Sims, Jr. <[EMAIL PROTECTED]> writes >Ok, I understand how you do this, but what if I want to select fields from >two tables? > >John
It's just the same... SELECT tutID, tutName, pupID, pupName, pupCourse FROM tutors, pupils WHERE pupCourse = tutCourse ORDER BY pupName, tutID Or ORDER BY pupils.pupName, tutors.tutID -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
