evaluating while querying?

[himansh]

hi guys,
is it possible to query a table and while querying it, evaluate one of it's field as reference to another table, then extract everything, or a few fields from that refference table.
please help. thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[inder]

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 --