mysql 多表查询

东成熙就

于 2016-05-06 21:45:06 发布

阅读量409

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql多表查询

本文链接：https://blog.csdn.net/phpfer/article/details/51334879

mysql 专栏收录该内容

1 篇文章

订阅专栏

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;