1. 首先，这两个表要有关系（比如主外）；2. 将有关系的键作为条件添加到where中；如：表t_message_info(c_id(primary key),c_name,c_type_id)表t_message_type(t_id,t_name)select *from t_message_info m,t_message_type t where m.c_type_id = t.t_id;或者可以使用子查询：select m.c_id, m.c_name, (select t.t_name from t_message_type t where t.t_id = m.c_type_id) from t_messag...
|
