What happens is that the columns in the joined table are all null.
students left outer join members on students.student_key = members.student_key
I should get something like this:
+----------------------+-----------------------+------------------- +---------------------+
| students.student_key | students.student_name | members.class_key | members.student_key |
+----------------------+-----------------------+------------------- +---------------------+
| 5 | Grace | NULL | NULL |
| 3 | Susie | NULL | NULL |
| 1 | Bill | 3 | 1 |
| 1 | Bill | 1 | 1 |
| 4 | Jean | 3 | 4 |
| 2 | John | 3 | 2 |
| 2 | John | 2 | 2 |
| 2 | John | 1 | 2 |
+----------------------+-----------------------+------------------- +---------------------+
But I get something like this:
+----------------------+-----------------------+------------------- +---------------------+
| students.student_key | students.student_name | members.class_key | members.student_key |
+----------------------+-----------------------+------------------- +---------------------+
| 5 | Grace | NULL | NULL |
| 3 | Susie | NULL | NULL |
| 1 | Bill | NULL | NULL |
| 1 | Bill | NULL | NULL |
| 4 | Jean | NULL | NULL |
| 2 | John | NULL | NULL |
| 2 | John | NULL | NULL |
| 2 | John | NULL | NULL |
+----------------------+-----------------------+------------------- +---------------------+
These are not the real tables, the real tables are around 2000 rows
I don't have this problem on a much smaller scale (see above) or in a InnoDB database with 2000 rows.
Yes, the columns are set to NOT NULL. I am using mysql 4.1.7.
Anyone seen this?
Thanks
kib
-- Klaus Berkling Systems Administrator DynEd International, Inc.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
