as you haven't told anything about the tables, how your executing the query etc. you need to look up Joins in the SQL that you are using
i.e.
SELECT a.*
FROM table1 a INNER JOIN Table2 b
ON a.ID = b.ID INNER JOIN Table3 c
ON a.ID = c.ID
WHERE a.id = 1234
Sql 2000 Join fundementals[
^]