mysql 多表查询

select project_main.projectid,project_introduce.videotype from project_main,project_introduce where project_main.projectid = project_introduce.projectid;

select project_main.projectname, project_introduce.projectid from project_introduce left join project_main on project_introduce.projectid = project_main.projectid;