Hi,
On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote: > I got 4 tables: > > Table A > | ID | Description1 | > > Table B > | ID | Description2 | > > Table C > | ID | Description3 | > > Table D > | ID | Description4 | > > ALL Ids ARE COMMON Values and NONE are MISSING > > How can I create > | ID | Description 1 | Description 2 | Description 3 | Description 4 | > > > > SELECT a.ID,a.Description1,b.Description2,c.Description3,d.Description4 > FROM TableA a > INNER JOIN TableB b ON a.id = b.id > > INNER JOIN TableC b ON a.id = c.id > > INNER JOIN TableD b ON a.id = d.id > > Doesn't give me the result > > What am I doing wrong? > Can I do this? > > > You have to do your joins in a chain: A joins to B, B joins to C, C joins to D, and so on. Here's how I made it work in a simple example: mysql> create table a (id int, desc1 varchar(255)); Query OK, 0 rows affected (0.13 sec) mysql> create table b (id int, desc2 varchar(255)); Query OK, 0 rows affected (0.00 sec) mysql> create table c (id int, desc3 varchar(255)); Query OK, 0 rows affected (0.07 sec) mysql> create table d (id int, desc4 varchar(255)); Query OK, 0 rows affected (0.00 sec) mysql> insert into a values (1, 'foo'); Query OK, 1 row affected (0.13 sec) mysql> insert into b values (1, 'bar'); Query OK, 1 row affected (0.00 sec) mysql> insert into c values (1, 'fu'); Query OK, 1 row affected (0.00 sec) mysql> insert into d values (1, 'br'); Query OK, 1 row affected (0.00 sec) mysql> select a.id,a.desc1,b.desc2,c.desc3,d.desc4 from a -> join b on a.id = b.id -> join c on b.id = c.id -> join d on c.id = d.id; +------+-------+-------+-------+-------+ | id | desc1 | desc2 | desc3 | desc4 | +------+-------+-------+-------+-------+ | 1 | foo | bar | fu | br | +------+-------+-------+-------+-------+ Hope that helps, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]