To get information from a second table based on a first, you need fields in both tables that are in common, e.g.:
SELECT t1.*, t2.*
FROM t1
JOIN t2 ON t1.t2id = t2.id
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --