mysql关于子查询和连接查询

两种写法，区别在最后一行，查询结果一样
select v.id id, product_id, t.id comp_id, comp_value, comp_file, time, file_path, cmpt_name, work_name, rate_time, real_time, count_down, book_id, cmpt_left, cmpt_top,cmpt_width, cmpt_height, font_size, font_name, cmpt_type, d.dict_label as cmpt_type_name, num_point, is_equal_begin, is_required, is_limit,is_equal_end, num_begin, num_end, cmpt_line, cmpt_operator, cmpt_role, cmpt_user, v.u

mysql关于子查询和连接查询最先出现在Python成神之路。