best guess though..
Code:
mysql> create table y1 (aID int auto_increment primary key, bID int, cID int, val_timestamp timestamp,val_char varchar(255));
Query OK, 0 rows affected (0.06 sec)
mysql> create table y2 (aID int auto_increment primary key, bID int, cID int, val_timestamp timestamp,val_float float);
Query OK, 0 rows affected (0.01 sec)
mysql> create table y3 (aID int auto_increment primary key, bID int, cID int, val_timestamp timestamp,val_int int);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into y1 values (1,1,1,curdate(),'qqqq');
Query OK, 1 row affected (0.00 sec)
mysql> insert into y2 values (1,1,1,curdate(),5.5);
Query OK, 1 row affected (0.00 sec)
mysql> insert into y3 values (1,1,1,curdate(),9);
Query OK, 1 row affected (0.01 sec)
mysql> select a.cID,a.val_timestamp,a.val_char,b.val_float,c.val_int from y1 a join y2 b on a.bID = b.bID join y3 c on a.bID = c.bID where a.bID = 1;
+------+---------------------+----------+-----------+---------+
| cID | val_timestamp | val_char | val_float | val_int |
+------+---------------------+----------+-----------+---------+
| 1 | 2009-12-14 00:00:00 | qqqq | 5.5 | 9 |
+------+---------------------+----------+-----------+---------+
1 row in set (0.00 sec)
Does that help ?