>Thanks,
>but was is wrong with the follow query:
>
>SELECT a.*, e.title, b.department, d.function, c.apostrophe
>FROM table1 a;
>INNER JOIN table b;
>INNER JOIN table c;
>ON a.b_id = b.id ;
>ON a.c_id = c.id ;
>WHERE a.number = "XXX"
You're referencing field
d.function from a table
d that is not in select.
--sb--