MS SQLServer 7:

is there an restriction on the number of joins in a query ?

something like this:

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 = "12020"

achim huber