Re: join all three tables

[Rodrigo Rueda]

I couln't understand the meaning of table B and C. Anyway...

It seems every line on table C matches a line in table B and you want it ordered (First line on table B matches first line on table C and so on... til the end of table C).

I would add another id field to table B and table C and remove the current id field from table C. So you can do 2 simple LEFT JOINs:

SELECT * FROM a LEFT JOIN b ON a.id=b.id LEFT JOIN c ON b.id2=c.id2;