RE: [PHP] Re: Help with query

2006-02-21 Thread Duffy, Scott E
57 AM To: php-general@lists.php.net Subject: [PHP] Re: Help with query Ing. Tomás Liendo wrote: > Hi I need the students that didn't take an exam. The tables: > > exams(id_test, title, desciption, ) > > results(id_student, id_test, date, qualification...) > > I'm

[PHP] Re: Help with query

2006-02-21 Thread Barry
Ing. Tomás Liendo wrote: Hi I need the students that didn't take an exam. The tables: exams(id_test, title, desciption, ) results(id_student, id_test, date, qualification...) I'm using a version of MySQL that doesn't support NOT IN, then I tried in this way: SELECT * FROM exams LEFT JOI

[PHP] Re: Help with query

2006-02-21 Thread Barry
Ing. Tomás Liendo wrote: Hi I need the students that didn't take an exam. The tables: exams(id_test, title, desciption, ) results(id_student, id_test, date, qualification...) I'm using a version of MySQL that doesn't support NOT IN, then I tried in this way: SELECT * FROM exams LEFT JOI

[PHP] RE: Help with Query

2001-10-22 Thread De Necker Henri
> Hi there. > > I have the following question for u. > I want to join two tables but it must be displayed in the a specific > format. > > The data of the tables are as follow : > > Table employee : > > idsurname initialsba > 1 PoepH ER >