RE: SQL QUERY help joining three tables

2002-03-16 Thread Roger Baklund
* John Hughes > I have three tables: > > students has student_id and student_name > parents has parent_id and parent_name > parentlog has student_id and parent_id > > I want to search the parentlog WHERE student_id = some_id > GROUP BY parent_id > > (This will bring back two rows when there are tw

SQL QUERY help joining three tables

2002-03-15 Thread John Hughes
SQL QUERY question I have three tables: students has student_id and student_name parents has parent_id and parent_name parentlog has student_id and parent_id I want to search the parentlog WHERE student_id = some_id GROUP BY parent_id (This will bring back two rows when there are two parents)